Split column
 

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.

Split column
 

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


On Fri, 8 Jun 2007 16:04:00 -0700, Dave Plyer
wrote:

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.

Split column
 

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

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

XL2002, WinXP


"Dave Plyer" wrote:

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.

Split column
 

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.

"Ron Coderre" wrote:

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

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

XL2002, WinXP


"Dave Plyer" wrote:

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.