software

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.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.comgt; wrote in message ups.com...
gt;I need to parse data similar to the following into separate
gt;columns -
gt; one column for last name, one column for first name and middle
gt; initial
gt; (or middle name) and one column for zip code. What is the best
gt; way to
gt; do this (least number of steps).
gt;
gt; Smith, John J 80909
gt; Carson, Mary S 80222
gt; Cleaver, Wally 80002
gt; Jones, John Paul 80019
gt; Latham, Stella G 90002
gt;
gt; Thank you.
gt;
Thank you. I didn't know that you could put in multiple delimiters in
text to columns. Great info to have. Thanks again.Thank you. I didn't know that you could put in multiple delimiters in
text to columns. Great info to have. Thanks again.