CSV With Quotes

[Glenn]

I need to save a file in this format:

"News","Microsoft","Today"

but when I pick .csv I get this format:

news,Microsoft,Today

I can't find an option for including the quotation marks around each field.

Can someone please tell me how to do this?

Thank you.

[goober]

With Windows certain characters are not allowed to be used in file names. Some of them are * ? " / \ : < > these are restricted by the OS and there isn't a way around it.

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/textf...#csvwithquotes

In article <[email protected]>,
"Glenn" <[email protected]> wrote:

> I need to save a file in this format:
>
> "News","Microsoft","Today"
>
> but when I pick .csv I get this format:
>
> news,Microsoft,Today
>
> I can't find an option for including the quotation marks around each field.
>
> Can someone please tell me how to do this?
>
> Thank you.

[Earl Kiosterud]

Glenn,

The Text Write Program at www.smokeylake.com/excel can do that. There's an
option in sheet Setup for text qualifiers around all fields.

Earl Kiosterud
www.smokeylake.com

"Glenn" <[email protected]> wrote in message
news:[email protected]...
>I need to save a file in this format:
>
> "News","Microsoft","Today"
>
> but when I pick .csv I get this format:
>
> news,Microsoft,Today
>
> I can't find an option for including the quotation marks around each
> field.
>
> Can someone please tell me how to do this?
>
> Thank you.
>
>