EXACT

Office Components Spreadsheet Function

Show All

EXACT

See Also

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(text1,text2)

Text1   is the first text string.

Text2   is the second text string.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

First string Second string
word word
Word word
w ord word
Formula Description (Result)
=EXACT(A2,B2) Checks whether the strings in the first row match (TRUE)
=EXACT(A3,B3) Checks whether the strings in the second row match (FALSE)
=EXACT(A4,B4) Checks whether the strings in the third row match (FALSE)