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.


---
Message posted from http://www.ExcelForum.com/

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


"MGAL " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.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
-----Original Message-----
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.


---
Message posted from http://www.ExcelForum.com/

.

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!


---
Message posted from http://www.ExcelForum.com/

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.



"MGAL <" wrote:

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!

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

That Worked! Thank-you Very Much!

--
Message posted from http://www.ExcelForum.com