Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting Names Down Columns
This one's a toughie... be prepared!
I have a spreadsheet with several thousand entries that should have been a database instead. It holds a lot of user information, such as names, numbers, addresses, etc. I need to the entries under the Name column into multiple colums. Specifically, Title1, First1, Middle1, Last1, Suffix1, Title2, First2, Middle2, Last2, Suffix2. Of course, all the entries under the Name column are not standard: Craig and Dolores Craig Jeffrey and Cynthia Beegle Jason Piel Mr Kaske Debra Cork-Wahl and Charles Cork Micro Systems Matthew G. Kovar and Karina Rand-Kovar Terrance and Mary Mathews The most common format is "First1 and First2 Last1/2", but that is not the case with a good chunk of the entries. No matter how you look at it, someone is going to have to go through it manually to make sure there are no mistakes, but I was hoping that there would be some way to script a semi-solution to cut down on some of the work. Any takers? :-) Thanks! Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting names | Excel Discussion (Misc queries) | |||
Question for Bob Phillips re Splitting Names from Cells | Excel Discussion (Misc queries) | |||
Splitting names from cells | Excel Discussion (Misc queries) | |||
splitting names & email add. | Excel Programming | |||
Siple but what was the formula for splitting names? | Excel Programming |