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.

See

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

In article <(E-Mail Removed)>,
"Glenn" <(E-Mail Removed)> 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.

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.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=493084

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>
>