I need to save my CSV file with double quotes around the cell contents and
then each cell separated by commas. If you add a comma to the cell contents,
it places double quotes, but includes the comma between them. Any quick way
to do this without some long script? This will be a daily function for our
HR department and need to make it as full proof as possible.

http://support.microsoft.com/default...b;en-us;291296
Procedure to export a text file with both comma and quote delimiters in
Excel

--
Regards,
Tom Ogilvy


"NavSysEng" wrote in message
...
I need to save my CSV file with double quotes around the cell contents and
then each cell separated by commas. If you add a comma to the cell
contents,
it places double quotes, but includes the comma between them. Any quick
way
to do this without some long script? This will be a daily function for
our
HR department and need to make it as full proof as possible.

THANK YOU! This is EXACTLY what I need and works exactly as planned!

"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;en-us;291296
Procedure to export a text file with both comma and quote delimiters in
Excel

--
Regards,
Tom Ogilvy


"NavSysEng" wrote in message
...
I need to save my CSV file with double quotes around the cell contents and
then each cell separated by commas. If you add a comma to the cell
contents,
it places double quotes, but includes the comma between them. Any quick
way
to do this without some long script? This will be a daily function for
our
HR department and need to make it as full proof as possible.