output csv delimited from excel

[JM39]

Hello, I have an input file in excel format and I want the output to be in csv format, which is fine. But some of my data contains commas so where it finds a comma in the data it creates an extra column in the output file. How do I get it to ignore the commas in data?

Example:

Input file shows the column supplier name:

Supplier Name

Extron Electronics, Europe

But in my csv output file it splits it out into two columns like

Supplier Name Column2

Extron Electronics Europe

Thanks!

[JM39]

Also I need to retain the commas in the data. So in my example I need the output file to show the supplier name as Extron Electronics, Europe

[JM39 · Accepted solution]

I got the answer. Changed my input file to delimited

[Anonymous]

Hello,

Thanks for letting us know that you resolved this issue by yourself.

Best regards

Sabrina