how to compare two columns and highlight those names which partially match

[ronakinuk]

Hi thank you for your help in advance
I have two columns both have over 100 names

for e.g.
Column A Column B
A.Smith claire jones
c.jones 1234 - camaroond
d.camaroon 2356 - johnsoe
e.johnson smith aron

please observe that both columns have same people but their names are not in the same format ,neither they are alphabetically sorted or anything

can you please help me with the macro that can match them
either highlight them , or it will be even better if we could replace those names that match in column b with column a names

thanks

[Guido Geurs]

I think there are only 2 solutions:

1- When a name must be entered: let the user select from a list with valid names and only these names so that a person only can represented by one valid name.

2- If option 1 is not possible: create a list of valid names and there possible writings.
Run through the names in the sheet and replace each wrong name with his valid name and then match the cells with the same name.

I think that option 1 is the most recommended if possible.