| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I split column? | Excel Discussion (Misc queries) | |||
| split column into 4 columns | Excel Discussion (Misc queries) | |||
| can i somehow put two cells into one column or split a column | Excel Discussion (Misc queries) | |||
| split a column | Excel Discussion (Misc queries) | |||
| How to split one column into two? | Excel Worksheet Functions | |||
Threaded Mode
