how to compare text fields in 2 different columns in excel

[ljt1]

[mickbarry]

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 "True" will be displayed.
If the data is different then "False" 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.

[Govind]

Hi,

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,"TRUE","FALSE")

Regards

Govind.

mickbarry wrote:

> 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 "True" will be displayed.
> If the data is different then "False" 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.
>
>