EXACT Function in Excel

EXACT Function

The exact function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If the two strings match, this function return True. If they do not match, it returns False.

Syntax:

=EXACT(text1,text2)

Let’s look at the following example below. Where the text strings are the same, it displays True. If one text value is blank, it will return False. If both cells are blank, it will return True. Please keep this in mind when using this function.

exact function in excel

Was this article helpful?

Related Articles

Leave a Reply