Split column

D

Dave Plyer

I have a column headed City,Zip. The data is comma delimited and the column
is formated as text. I highligt the column, click Data/Text to
Column/Delimited/comma. The Wizard shows the data separated in two column as
I want but when I click Finish/OK, the commas and the zip codes disappear
rather than appear in a column to the right. Help please.
 
G

Gord Dibben

Dave

The commas will disappear because you used a comma as a delimiter.

The Zip column may be selected as "do not import column(skip)" in third step.

Uncheck that option by hitting the "General" button.


Gord Dibben MS Excel MVP
 
R

Ron Coderre

On step 3 of Text-to-columns, is the 2nd column set to "Do not import column"?

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
D

Dave Plyer

Thanks for your reply. I assumed your question meant that I should not select
"Do not import column." Therefore, I checked General and the result is what I
wanted: city in one column and zip in the one to its right. Thank you.
 
Top