rmarcus my problem has extended. Text to columns was Ok when there were equal numbers of given names before the surname. But how or can I use test to columns when there may be from one or two or three etc given names. The text to columns separates all given names (using the space as a delimter) which I don't want. I need to pick off the last name (the name before the last space)and place it into the next column and leave the rest behind. Thanks for your previous help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2000 Separating names
- Thread starter PhilF
- Start date
Phil:
I always use the text to columns. Just take the names to another worksheet to do the TTC, if that's possible--it may not be and you just need to insert a whole bunch of blank columns to the right of the name before you start. Basically, you will need to get all of your names to take up as many columns as necessary.
Do the TTC, then sort your list so that all the people with only 2 names come to the top (sort by the 3rd column). Then insert Column b cells for anyone with just two names. Then sort by the 4th column, and insert columns for anyone needing the extra cell, and so on. I hope this makes sense. It sounds lame in writing!!
techsupportgirl@home.com
Brainbench MVP for Microsoft Word at
I always use the text to columns. Just take the names to another worksheet to do the TTC, if that's possible--it may not be and you just need to insert a whole bunch of blank columns to the right of the name before you start. Basically, you will need to get all of your names to take up as many columns as necessary.
Do the TTC, then sort your list so that all the people with only 2 names come to the top (sort by the 3rd column). Then insert Column b cells for anyone with just two names. Then sort by the 4th column, and insert columns for anyone needing the extra cell, and so on. I hope this makes sense. It sounds lame in writing!!
techsupportgirl@home.com
Brainbench MVP for Microsoft Word at
- Status
