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