=IF(A1=B1,"Same","")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TEB2" wrote in message
...
I have 2 columns of names. #1 has the full legal name and #2 has their
more
common name.

How do you compare the 2 to see if they are similar?