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 January 16, 2023 - 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 January 16, 2023 549
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
0

Similar discussions

Search a list of names at one time in excel
priya_mbial -
priya_mbial -

8 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses