new line problem?

[ace2302]

Hi all,

I have a problem uploading a converted excel file (tab delimited) to a shopping site, my supplier provides me with an excel price list with all product descriptions, prices, bar codes etc, when I input these details into my excel template all looks OK. But I am being told the description fields are not correct
Could somebody have a look at the attached template to see if there are any glaring errors which I cant see?

Mucho grassy ***

[Mikeopolo]

the column 'mpn' has been converted to 4.89E+12 for example. This must be a product code. You may need to prevent that from happening (convert field to text on import or format as text before saving).

Regards
Mike

[ace2302]

Thanks for looking

Yes I know about the 'mpn' column it is like that every time I re-open excel.
Its the 'description' cells that are causing the problem and I cant see what is wrong with them

[Mikeopolo]

OK, I see another problem, some of the description fields have commas in them, and Excel has placed quote marks around the field.

You need to remove those - edit the txt file and edit/replace all quotes with nothing and save it.

Regards
Mike