Saving CSV file in excel format

[michelleooffice2]

Hi everyone! I have ready many threads on this, but can't seem to find a simple solution (that I understand).

I am using an online courier website that uses an csv file to upload addresses to an address box. I need to be able to export addresses from my customer database to calc, then save in csv format from calc.

However the website only supports the excel format - the difference being that in excel any strings containing a comma get wrapped in quotes, whilst the remaining strings are left without quotes. Whereas in calc, I have the option to either have all the text strings wrapped in quotes, or none wrapped in quotes.

I.e;
Excel:
Mr. Ranom,"Unit2, 20 Random Street",RandomTown,RandomCountry

Calc:
"Mr. Random","Unit2, 20 Random Street","RandomTown","RandomCounty"
OR
Mr. Ranom,Unit2, 20 Random Street,RandomTown,RandomCountry

The problem obviously being in the second example of calc, the info is not submitted to the website correctly because the comma means all the info is shiften over by one column.

I don't know how to do macros, or how to write any programs etc. But I really need a solution to this. I need it to be simple enough that my staff can get the address from our database to the courier website without to much mucking around.

I really do appreciate any help you can offer!
Michelle

[davidh182]

You could create a second page which simply copies sheet 1 but puts quotes in if the cell contains a comma, then save that page.