Parsing Data

  • Thread starter Thread starter MGAL
  • Start date Start date
M

MGAL

How do I parse data that is in the same column and contains different
lengths of text strings. I have a column that contains city, state,
and zip. I want to split the city, state and zip into three different
columns.
 
Exactly what do the cells contain? What separates the city name
from the state, and what separates the state from the zip code?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You could try Data, Text to Columns. this will split the
information provided that each city, state and zip is
divided by the same separator, eg. coma, space or tab.

Make sure that you have two empty columns to the right to
place the data or the existing information in those
columns will be overwritten.

Peter Atherton
 
The cells look like this:'

Carson City, NV 60515
Naperville, IL 60540

I have tried Text-to-Columns, but because of the different text string
as far as the city goes, I am stumped!
 
Maybe you could do the Data|Text to columns twice.

The first time, use delimited (by commas) to separate the city from everything
else.

Then the second time use spaces to separate the state from the zip.
 
Back
Top