Compare two text strings
A boolean value (TRUE or FALSE)
=EXACT (text1, text2)
- text1 – The first text string to compare.
- text2 – The second text string to compare.
EXACT will compare two text strings and return TRUE if they are the same, and FALSE if not. EXACT is case-sensitive.
You can also use the equal sign in a formula (text1=text2) to compare text strings. However, the equal sign is not case sensitive.