EXACT

The EXACT function returns TRUE if the argument strings are identical in case and content.

EXACT(string-1, string-2)

string-1: The first string value.

string-2: The second string value.

Examples

=EXACT(“toledo”, “toledo”) returns the boolean value TRUE, because all the characters and their cases are identical.

=EXACT(“Toledo”, “toledo”) returns the boolean value FALSE, because the case of the two strings is not identical.

See also
FIND
SEARCH