EXACT

The EXACT function in Excel is used to compare two text strings for exact equality. It returns TRUE if the strings are identical, including letter case, and FALSE if they are different.

Syntax

=EXACT(text1, text2)

text1 The first text string for comparison.
text2 The second text string for comparison.

About EXACT

When you need to verify if two text strings are exactly the same, down to the last character and even letter case, the EXACT function comes to the rescue in Excel. Whether you're working on data validation, error checking, or simply comparing information, EXACT ensures precision in your assessments by detecting any subtle differences between strings, including spaces and special characters. It's a handy tool for confirming perfect matches in your dataset and facilitating accurate decision-making based on text comparisons.

Examples

Check if two text strings 'Apple' and 'Apple' are exact matches using the EXACT function. The formula would be: =EXACT("Apple","Apple")

Verify if 'excel' and 'Excel' are identical using EXACT. The formula would be: =EXACT("excel","Excel")

Questions

What does the EXACT function return if the two text strings are identical?

If the two text strings are exactly the same, including case sensitivity, the EXACT function returns TRUE.

Does EXACT consider extra spaces or special characters in text comparisons?

Yes, EXACT considers extra spaces or special characters in text comparisons. Even a single space or special character difference will result in EXACT returning FALSE for two strings that may appear similar visually.

Is the EXACT function case-sensitive?

Yes, the EXACT function is case-sensitive. It differentiates between uppercase and lowercase letters in text comparisons.

Related functions

IF
IFERROR
ISNUMBER
ISTEXT
CONCATENATE