Parsing 'FullName' column - help needed text to column
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.
|