EXACT (compare texts)

Navigation:  Formulas and functions > Functions from A to Z >

EXACT (compare texts)

Previous pageReturn to chapter overviewNext page

Syntax:

EXACT(Text1, Text2)

Description:

This returns TRUE if Text1 and Text2 are exactly the same.

This function is case-sensitive.

Example:

EXACT("aaa", "aaa") returns TRUE

EXACT("aaa", "Aaa") returns FALSE

EXACT(UPPER("aaa"), UPPER("Aaa")) returns TRUE

See also:

FIND, SEARCH, DELTA