Last Name First Name Formula

[jakewashburn]

Hi All,

New member from Philly. I am working with data from the city of Philadelphia, my biggest issue is the Owner Name column has both first name last name and last name first name with no rhyme or reason. For example one cell has John A Smith and the other has Smith A John, completely inconsistent. I reached out to the contact at the city to inquire if there was a certain date when they changed the order of names, but I checked manually and it seems completely random.

1. I did text to column (original name in column A)
2. I tried to determine whether column B or C was a first name based on the FirstNames tab in the document
3. I have a First Name Output which is the desired result for first name highlighted in green
4. I am having trouble where the vlookup detected two first names and I do not how to tell the if formula to put the correct name

I know I am close, could someone help me cross the finish line?

Do you think there's a better way to do this?

I would like to try to keep the FirstName tab as the vlookup because there are clearly first names that should be last names in my case.

Thank you,
Jake

[63falcondude]

Hello and welcome to the workbook.

See attachment.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This formula got about 80% of the names sorted correctly.

The other 20% are shown as blank and were not found in the FirstNames worksheet.
A lot of those are company names.

[jakewashburn]

63falcondude

This is amazing, thank you so much for your help and quick reply!!!!

[63falcondude]

Happy to help. Thanks for the rep!

By the way, to mark your thread as solved, you can select Thread Tools from the menu link above and mark this thread as SOLVED instead of changing your thread title.

[jakewashburn]

Thank you again!