Compare part of a cell to a column

[JessicaZ]

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.

 

[JessicaZ]

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.