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

Text1   is the first text string.

Text2   is the second text string.

Examples

EXACT("word","word") equals TRUE

EXACT("Word","word") equals FALSE

EXACT("w ord","word") equals FALSE

To make sure that a user-entered value matches a value in a range, enter the following formula as an array in a cell. To enter an array formula, press CTRL+SHIFT+ENTER in Microsoft Excel 97 for Windows or COMMAND+ENTER in Microsoft Excel 97 for the Macintoch. The name TestValue refers to a cell containing a user-entered value; the name CompareRange refers to a list of text values to be checked.

{=OR(EXACT(TestValue, CompareRange))}