comma delimited not seperating into columns

S

STEVE

Just updated Microsoft Service Pack 2, now my Excel won't seperate imported
comma delimited into columns.
Imported data comes with commas, but won't seperate into seperate columns.
What can I do?
Thanks
 
G

Gord Dibben

Steve

Try changing the incoming file to *.TXT if you are using *.CSV

Excel's Text to Columns Wizard will open allowing you to separate.

Gord Dibben Excel MVP
 
Top