EXACT function

EXACT (Text1, Text2) EXACT (Text1; Text2)

Text1

Text Text

The first text string to test.

Text2

Text Text

The second text string to test.

Returns

Logical Logical

Whether the given text strings are identical, taking into account case.

Returns whether the two text strings are identical, in terms of content and in terms of case. EXACT ("ab", "AB") EXACT ("ab"; "AB") returns FALSE, because the comparison is done in a case-sensitive manner. "ab" = "AB""ab" = "AB", however, returns TRUE, because the = operator is not case-sensitive.

EXACT exists primarily to perform case-sensitive text comparisons. The operator == (which is not commonly supported by spreadsheets) is also case-sensitive, meaning that "ab" == "AB""ab" == "AB" returns FALSE.

Examples

EXACT ("ab", "AB")

EXACT ("ab"; "AB")

Returns FALSE, because the comparison is done in a case-sensitive manner.

"ab" = "AB"

Returns TRUE, because the = operator is not case-sensitive.

"ab" == "AB"

Returns FALSE, because the == operator is case-sensitive.

EXACT ({ "ab", "test" }, { "AB", "test" })

EXACT ({ "ab"; "test" }; { "AB"; "test" })

Returns the array { FALSE, TRUE }{ FALSE; TRUE }. The first element is FALSE because "ab" and "AB" are not considered identical by EXACT due to the case-sensitive text comparison. The second element is TRUE, because "test" and "test" are considered identical.