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