EXACT function

Category: Text functions

What does this function do?

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. 

Syntax:

EXACT(text1, text2)

• Text1 (required): The first text string.
• Text2 (required): The second text string.

Examples:

=EXACT(“The wizard of Excel”,”The wizard of Excel”) = TRUE
=EXACT(“The wizard of Excel”,”The wizard of excel”) = FALSE

If A1=”The wizard of Excel”

=EXACT(“The wizard of Excel”,A1) = TRUE
=EXACT(A1,”The wizard of excel”) = FALSE

Bonus:

This function can also be written like this:

=”The wizard of Excel”=”The wizard of Excel” = TRUE
=”The wizard of Excel”=”The wizard of excel” = FALSE

If A1=”The wizard of Excel”

=”The wizard of Excel”=A1 = TRUE
=”The wizard of excel”=A1 = FALSE