Split column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 step 3 of Text-to-columns, is the 2nd column set to "Do not import column"?

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

XL2002, WinXP
 
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.
 

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

Import of Text Delimited file into excell 1
Text to Rows? 3
How to use the "shell" command? 10
Text to columns 2
*.csv format change if .xlt save as .csv in Excel 2007 1
Trying to split up info in one cell to several 2
Text to Columns 1
Text to rows? 1

Back
Top