Parse data with uneven lengths and different delimiters

S

smulhern

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.
 
C

Chip Pearson

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
 
B

Buffgirl71

Thank you. I didn't know that you could put in multiple delimiters in
text to columns. Great info to have. Thanks again.
 
B

Buffgirl71

Thank you. I didn't know that you could put in multiple delimiters in
text to columns. Great info to have. Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing Question 4
help with combo boxes and duplicate entrys 2
Reordering and combining data 3
Request for help with EXCEL 2003 2
Offset function with inconsisent data location 1
Comparing fields and records and updating records 2
Copy multiple values into a single cell 4

Top