Hey every one. I'm working a project and need some help. I've stared at this so long I'm afraid I can't see the forest for the trees.



I have an address DB from a client and need to parse out the FullName field to normalize it for them. The issue I have is that they were not consistent in how they input the records over time so just using text to columns isn't working for me.

A lot of their lists were being maintained directly in a Word document label sheets. (Converting that was a real joy! NOT)

You can see in the attached sample there is a real mishmash of data there.
Salutations / titles - full middle names vs. just initials - dual names - and on and on.

One thing I thought of: Is there a way to determine the number of "words" in a cell? At least if I could sort by that I could handle the rows that are similar.

Any suggestions welcome! I have about 25 - 30K records to deal with.

Attached Files

SampleNamesWB.xlsx (11.2 KB, 12 views)