CSV Files

S

Susan Govier

Hi,

I want to open a CSV file in Excel, but Excel is opening
it without giving me the option to choose how the file is
delimited/fixed. Are there setting in Excel that I need
to alter to be able to do this?

Any help greatly appreciated.

Thanks
 
C

Chip Pearson

Susan,

Change the file extension from csv to txt and use the text import wizard.
This allows you to control the way in which Excel interprets the data.
 
Top