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) |