Compare 2 lists of names

[Closed]
Report
Posts
1
Registration date
Monday November 25, 2013
Status
Member
Last seen
November 25, 2013
-
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
-
Hello,

I have 2 lists of names with last name and first name. However, one on list there is a comma and a middle initial on the other there is just last name and first name. I know that some people are missing from one of the lists. How do I compare them since they are not formatted the same?

Regards.

1 reply

Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
484
Hi Wiesh,

Excel's text delimiter option could be an easy solution for you.

In Excel 2003 it is found in the top menu's under "Data".

Best regards,
Trowa