View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default importing csv files- entire record goes into each column

Hi,

I think your current selecion is just a cell in cell A1, before downloading.
Select all
columns by clicking the left corner - Above row 1 and left of column A - and
then try downloading again. This will display all the data as stored in the
CSV file.

Note: Although the source file may be delimited, you are just specifying a
single cell as selection for importing data, therefore, Microsoft Excel
assumes that you want to import all your data only into that particular cell.

Challa Prabhu


"Bill" wrote:

This used to work before but now whenever I import a .csv file (I've
tried each one that used to work before) entire records are being put
into each column variable but the commas are still there. There must be
a setting for this (looks like it doesn't recognize the comma any more)
but darned if I can find it. I went into control panel and
Regional/Laguages-- Customize and it already said that the separator
char was a comma...

Anyplace else I can check?

thanks,
Bill