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.