This function returns true if two strings are the same; otherwise, false.

Syntax

EXACT(text1,text2)

Arguments

The arguments are text strings.

Remarks

This function compares the string in the first argument to the string in the second argument.

Although this function is case-sensitive, it ignores formatting differences.

Data Types

Accepts string data for both arguments. Returns boolean data (true or false).

Examples

EXACT(A3,A5)

EXACT(R3C1,R5C1)

EXACT(""SPREAD"",""spread"") gives the result FALSE