software

Thought I'd dust the cobwebs off this one as it seems to be very old.
Suppose text1 is in A1 and text2 is in A2 .
Then =a1=a2 should do the trick.
If the data is the same then quot;Truequot; will be displayed.
If the data is different then quot;Falsequot; will be displayed.

Regards Mick Barry
You know that you are getting old,
when you finally reach the top of the ladder,
and find it leaning against the wrong wall.--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: www.excelforum.com/member.php...oamp;userid=31028
View this thread: www.excelforum.com/showthread...hreadid=493566Hi,

If the Text data needs to be matched exactly including the Uppercase or
lowercase, then use

=EXACT(A1,A2)

This will return true, when text in A1 and A2 are exact match.

If you dont want to do an exact match including case, then use

=IF(A1=A2,quot;TRUEquot;,quot;FALSEquot;)

Regards

Govind.

mickbarry wrote:

gt; Thought I'd dust the cobwebs off this one as it seems to be very old.
gt; Suppose text1 is in A1 and text2 is in A2 .
gt; Then =a1=a2 should do the trick.
gt; If the data is the same then quot;Truequot; will be displayed.
gt; If the data is different then quot;Falsequot; will be displayed.
gt;
gt; Regards Mick Barry
gt; You know that you are getting old,
gt; when you finally reach the top of the ladder,
gt; and find it leaning against the wrong wall.
gt;
gt;