Thread: Split column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Plyer Dave Plyer is offline
external usenet poster
 
Posts: 3
Default 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.