help needed urgently

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard354 - 31 Jul 2006 14:00 GMT

hi there,

i'm trying to export my records from excel to a csv file format, but i
need to have all text fields to be surrounded by "" marks like the
following format:

MY PRODUCT NAME

now needs to be:

\"MY PRODUCT NAME\"

but i have over 4000 records, and doing this by hand is going to be
impossible in the time frame.

Does anyone know a function which could automatically do this for me.

Signature

richard354

Reply to this Message

Dave Peterson - 31 Jul 2006 14:17 GMT

I think that Earl Kiosterud's program will do what you want right out of the
box:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

> hi there,
>
[quoted text clipped - 18 lines]
> richard354's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36952
> View this thread: http://www.excelforum.com/showthread.php?threadid=566608

Signature

Dave Peterson

Reply to this Message

Beege - 31 Jul 2006 14:18 GMT

Richard

Maybe....

="\"""&A1&"\"""

will help

Beege

> hi there,
>
[quoted text clipped - 12 lines]
>
> Does anyone know a function which could automatically do this for me.

Reply to this Message

Beege - 31 Jul 2006 14:25 GMT

Then again, maybe not. Sorry

> Richard
>
[quoted text clipped - 22 lines]
>>
>> Does anyone know a function which could automatically do this for me.

Reply to this Message