export to CSV file

[_Ann_]

I am exporting an Excel worksheet to a CSV file. I need each value in the
CSV file to be surrounded by double quotes. How do i do that? Thanks in
advance!

 

[Sheeloo]

CSV is Comma Separated... not quote comma separated.

You will have to either add quotes around each value or use a macro.

See http://support.microsoft.com/kb/291296 for a macro solution.

 

[_Ann_]

yeah i get the comma-separated point. But i find it odd that Excel will add
quotes if there is a comma in one of the cells. Was hoping for a bit more
flexibility in formatting the comma-separate values. The app that will use
the CSV files requores quoted values.

Thanks for the link. I'll give it a try.

 

[Sheeloo]

It has to add quotes if the cell value contains a comma since the values are
separated by commas in CSV... otherwise the values with commas will be split
over two or more fields...

While answering a post we have no idea about the level of expertise of the
person asking the questions so sometime we come across as condescending...

 

[_Ann_]

no offense taken Thanks for your help.

It has to add quotes if the cell value contains a comma since the values are
separated by commas in CSV... otherwise the values with commas will be split
over two or more fields...

While answering a post we have no idea about the level of expertise of the
person asking the questions so sometime we come across as condescending...