Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

EXACT

Description: 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:

• EXACT("word","word") = TRUE

• EXACT("Word","word") = FALSE

• EXACT("w ord","word") = FALSE