CSV File with double quotes

[Guest]

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.

 

[Tom Ogilvy]

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

 

[Guest]

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