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