export to CSV file
 

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!

export to CSV file
 

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_" wrote:

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!

export to CSV file
 

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" wrote:

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_" wrote:

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!

export to CSV file
 

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_" wrote:

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" wrote:

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_" wrote:

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!

export to CSV file
 

no offense taken :-) Thanks for your help.

"Sheeloo" wrote:

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_" wrote:

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" wrote:

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_" wrote:

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!