Previous Topic Next Topic

Compare 2 lists of names

Closed
wiesh Posts 1 Registration date Monday 25 November 2013 Status Member Last seen 25 November 2013 - 25 Nov 2013 à 14:30
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 28 Nov 2013 à 11:21
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Nov 2013 à 11:21
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

Similar discussions

How can I make a WhatsApp profile name
Dtttedyhvfdr -
boboten -

1 response