Exact function

Compares two text strings and returns the logical value 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.

Examples

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