Double quoting everything

Associate
Joined
31 Jan 2007
Posts
1,861
Hello,

I have an excel spreadsheet which i am converting to csv, I want everything in each cell to be double quoted. Is there a quick and easy way to double quote the contents of each cell whilst in excel so when i save as a csv it's all pre double quoted for me?
 
hmm, yeh, I would first like to see if there is anyway I could insert a comma at the start and end of every cell in excel before exporting as a csv
 
Back
Top Bottom