Working with Text

[Guest]

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?

 

[Lonnie M.]

Hi, you might give the following post a look:

http://groups-beta.google.com/group...67284780705/a0c1d7bb20684b62#a0c1d7bb20684b62

HTH -- Lonnie M.

 

[Bob Phillips]

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

--

HTH

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