Sponsored Link
Purpose
Compare two text strings
Return value
A boolean value (TRUE or FALSE)
Syntax
=EXACT (text1, text2)
Arguments
- text1 – The first text string to compare.
- text2 – The second text string to compare.
Usage notes
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.
