View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick B
 
Posts: n/a
Default Comma delimiter for csv downloads?

If you open one of the files in Notepad, before opening in Excel, can you
verify that the files have commas and not another delimiter?
Are the files being saved with the .csv extension, or by any chance are they
being saved with .csv.txt extension? (i.e. the actual extension is being
hidden -- open My Computer, Tools-Folder Options, View tab and verify that
Hide extensions for known file types is NOT selected.)

"Les M" wrote:

I have recently upgraded to Windows XP Home edition and have reinstalled all
my applications. I regularly download csv files from one particular site and
use them in Excel, but now they always download with all data in column A (in
the past they downloaded correctly as csv files, using separate columns).

In Control panel/Regional settings, comma is specified as the list
separator, but this is not having the required effect.

I can go through the "Data/Text to Columns/Delimited/comma" process each
time I download (and that process works), but I would like the default to
operate as it should.

Any helpful advice would be appreciated.