Using the Excel EXACT Function
SummaryThe Excel EXACT function will compare two text string and return TRUE if the are an exact match. If they are not, the function returns FALSE. The function is case-sensitive, but does ignore formatting differences.
Syntax=EXACT (text1, text2)
Required. The first text string.
Required. The second text string.
Usage NotesEXACT examines two text strings and will return TRUE if they are an exact match and FALSE if they are not. The function is case-sensitive.
It is possible to use the equal sign (text1=text2) when you need to compare text strings. However, this method is not case-sensitive.