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