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.