Tests if two strings are identical. Returns TRUE if the strings are identical.
- text1 - The first string to be checked.
- text2 - The second string to be checked.
EXACT("word","WORD") returns FALSE.
EXACT(C5,C6) returns TRUE if the strings in C5 and C6 are identical.
- EXACT requires the two strings to have the exact same characters, including identical case and identical spaces or hidden characters.