CSV With Quotes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 13 Dec 2005 17:18 GMT

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.

Reply to this Message

JE McGimpsey - 13 Dec 2005 17:23 GMT

See

http://www.mcgimpsey.com/excel/textfiles.html#csvwithquotes

> I need to save a file in this format:
>
[quoted text clipped - 9 lines]
>
> Thank you.

Reply to this Message

goober - 13 Dec 2005 17:29 GMT

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.

Signature

goober

Reply to this Message

Earl Kiosterud - 13 Dec 2005 20:11 GMT

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

>I need to save a file in this format:
>
[quoted text clipped - 10 lines]
>
> Thank you.

Reply to this Message