Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse data with uneven lengths and different delimiters
I need to parse data similar to the following into separate columns -
one column for last name, one column for first name and middle initial (or middle name) and one column for zip code. What is the best way to do this (least number of steps). Smith, John J 80909 Carson, Mary S 80222 Cleaver, Wally 80002 Jones, John Paul 80019 Latham, Stella G 90002 Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse data with uneven lengths and different delimiters
Use the Text To Columns tool under the Data menu. Use a comma and
a space as the delimiter character. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message ups.com... I need to parse data similar to the following into separate columns - one column for last name, one column for first name and middle initial (or middle name) and one column for zip code. What is the best way to do this (least number of steps). Smith, John J 80909 Carson, Mary S 80222 Cleaver, Wally 80002 Jones, John Paul 80019 Latham, Stella G 90002 Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse data with uneven lengths and different delimiters
Thank you. I didn't know that you could put in multiple delimiters in
text to columns. Great info to have. Thanks again. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse data with uneven lengths and different delimiters
Thank you. I didn't know that you could put in multiple delimiters in
text to columns. Great info to have. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|