#1
|
|||
|
|||
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. |
Tags |
parsing data, text to column |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
keep each item/cell in column A associated with a group in column C | ht889 | Excel | 1 | 02-25-2014 12:36 PM |
Columns. How to move the left column so it's to the right of the 'right' column ? | Vit | Word | 9 | 11-21-2012 12:57 PM |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
Need to search a column for a macth and return a result from a third column | pdfaust | Excel | 2 | 02-03-2011 03:02 PM |