Compare two strings

An excel formula to compare two strings

Related Functions

=EXACT(text1, text2)

If you need to two text strings in Excel to determine if they're equal, you can use the EXACT function. For example, if you want to compare A2 with B2, use:


If the two strings are identical, EXACT will return TRUE. If not, EXACT will return FALSE. You can use this result inside the IF function to display a message or make a conditional calculation. For example, to display the message "Yes" for a match and "No" if not, use:


Note that the EXACT function is case sensitive. If you don't care about case, you can simply use the equal sign like so:


This formula will return TRUE or FALSE, but will treat "Apple" and "apple" as the same.

0 votes. 0 / 5