CSV Files

  • Thread starter Thread starter Susan Govier
  • Start date Start date
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
 
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.
 
Back
Top