How to Use EXACT in Google Sheets in 2020?

EXACTTests whether two strings are identical.

Sample Usage

EXACT(A1,A2)

EXACT(“foo”,A3)

Syntax

`EXACT(string1, string2)

string1 – The first string to compare

string2 – The second string to compare

Notes

EXACT requires the two strings to have the exact same characters, including identical case and identical spaces or hidden characters.

Examples