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.