CSV File with double quotes

[NavSysEng]

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...b;en-us;291296
Procedure to export a text file with both comma and quote delimiters in
Excel

--
Regards,
Tom Ogilvy


"NavSysEng" <[email protected]> wrote in message
news:[email protected]...
> 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.

[NavSysEng]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>