Previous Topic Next Topic

Compare 2 lists of names

Closed
wiesh Posts 1 Registration date Monday November 25, 2013 Status Member Last seen November 25, 2013 - Nov 25, 2013 at 02:30 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 28, 2013 at 11:21 AM
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.
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Nov 28, 2013 at 11:21 AM
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