EXACT

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive. Use EXACT to test text being entered into a document.

Syntax

EXACT(text1,text2)

Text1   is the first text string.

Text2   is the second text string.

Example

Col1Col2Formula Description (Result)
wordword=EXACT([Col1],[Col2]) Checks whether the strings match (TRUE)
Wordword=EXACT([Col1],[Col2] Checks whether the strings match (FALSE)
w ordword=EXACT([Col1],[Col2]) Checks whether the strings match (FALSE)