Exact
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
Syntax
EXACT(value1, value2)
The EXACT function syntax has the following arguments:
- value1 (Required) The first text string.
- value2 (Required) The second text string.
Example
| First string | Second string |
|---|---|
| word | word |
| Word | word |
| w ord | word |
| Formula | Description | Result |
|---|---|---|
| =EXACT([Table]![1][1],[Table]![2][1]) | Checks whether the strings in the first row match | true |
| =EXACT([Table]![1][2],[Table]![2][2]) | Checks whether the strings in the second row match ("W" is uppercase in [1][2]) | false |
| =EXACT([Table]![1][3],[Table]![2][3]) | Checks whether the strings in the third row match ([1][3] contains a space between "w" and "ord) | false |
Updated almost 2 years ago