Compare part of a cell to a column

G

Guest

I have 2 lists that need to be compared. They have the same info, but
slightly different. For instance, one of them has "Mr. Bob Smith" in one
cell. The other list just has "Bob Smith". I need to compare the 2 columns
and delete or mark the duplicates. So basically I need to compare part of
each cell in the column on the first sheet to a cell in a column in the
second sheet.
 
G

Guest

OK, I figured out the text to column thing :)
Not what is the easiest way to do a comparison between 2 spreadsheets that
do not have identical data? One has email addresses and one just had regular
addresses, along with the names, so I just want to compare names and get
duplicates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel partial cell compare to another cell 0
check first 3 characters of a cell and compare to a table 4
Data Compare 5
Excel Comparing two columns 1
compare column 7
Compare multiple cells and highlight differences 5
Excel Linking Multiple cells to One cell for Results 0
Spilting a column 6

Top