How to Use EXACT Function

The EXACT function is the function to compare two text strings and identify whether they are the same. The function returns "True" when the two text strings are the same, and returns "False" when the two text strings are different.

The EXACT function is case sensitive, that is, upper case letter "A" is identified as different from lower case letter "a".

Formula:

= EXACT(text1, text2)

Explanations:

– Text1 is required, the first part of the text that you need to compare;

– Text2 is required, the second part of the text that you need to compare.

Cautions:

– The EXACT function ignores the formatting, but it is case-sensitive, so you need to be careful when using this function. For example, James is different from James.

Example: To compare column A and column B?

=Exact(A7,B7)
The result of comparison of A7 and B7 returns to "False" because there is one extra space after Mason MILLER in cell A7.

Download: EXACT Function

Leave a Reply