Surrounding data fields in quotes when saving to csv

[CorDataGary]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm trying to format data in a csv for a app that requires each data field to be framed in quotation marks. I've attempted saving the csv after formating all cells as text, but it doesn't add the "" for me.

I don't know VB, so as simple a solution as possible, please.

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm trying to format data in a csv for a app that requires each data field to
be framed in quotation marks. I've attempted saving the csv after formating
all cells as text, but it doesn't add the "" for me.

I don't know VB, so as simple a solution as possible, please.

You can do it without VBA. In a new worksheet in the same workbook, add the
following formula in cell A1:
=""""&othersheetname!A1&""""

Then fill this down and across for as many cells as there are in the
original sheet. Move this sheet to the first sheet in the workbook, and then
save as a CSV. Delete the sheet when you are done if you don't want it in
the workbook.