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

Col1	Col2	Formula	Description (Result)
word	word	=EXACT([Col1],[Col2])	Checks whether the strings match (TRUE)
Word	word	=EXACT([Col1],[Col2]	Checks whether the strings match (FALSE)
w ord	word	=EXACT([Col1],[Col2])	Checks whether the strings match (FALSE)