Excel: Exact Function

In Excel, the Exact function compares two strings and returns TRUE if both values are the same. Otherwise, it will return FALSE.

The syntax for the Exact function is:

Exact( text1, text2 )

text1 and text2 are the values to compare.

The Exact function is case-sensitive.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Exact(A1, A2) would return FALSE

=Exact(A1, A4) would return TRUE

=Exact(A1, A3) would return FALSE

=Exact(A4, "Alphabet") would return TRUE