saving as CSV format, problem with hidden format

[tsil]

Hi !

I have an excelfile with about 10 columns of data with about 10 raws.

I save this file as CSV, then I can look in note pad that it looks ok with comma separation. I get this excelfile from another company and it has been working until recently,

Now when I open up the csv saved excel in note pad the raw look like a string: "a;d;f;a;r " (it should look like: a;d;f;a;r)

I have tested to copy and paste an old excel row before saving it into CSV, then it looks correct; that is: a;d;f;a;r (that is, no "" signs)

I have tried to find the differencies in the format of the raws but I connot find any, is there away to find this or is it hidden for normal users ? Or even better , is the a way to solve this.... ?

BR

 

[Andrew Poulsom]

In Start|Settings|Control Panel|Regional Options|Numbers tab is your List Separator a comma or a semicolon?

If it's a comma and the person who sent it to you has semicolon, I don't think csv import will work. Try changing the file extension from csv to txt and specifying delimited with semicolon in the Text Import Wizard.

 

[tsil]

Thanks I had a look in the new excel I got and there is was, a cell containing a comma, when I removed that it worked again.