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

Version Available

This function is available in product version 1.0 or later.

See Also

CONCATENATE | Text Functions