help needed urgently

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.

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)

richard354 wrote:
>
> 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.
>
> --
> richard354
> ------------------------------------------------------------------------
> richard354's Profile: http://www.excelforum.com/member.php...o&userid=36952
> View this thread: http://www.excelforum.com/showthread...hreadid=566608

--

Dave Peterson

Richard

Maybe....

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

will help

Beege

"richard354" <[email protected]> wrote
in message news:[email protected]...
>
> 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.
>
>
> --
> richard354
> ------------------------------------------------------------------------
> richard354's Profile:
> http://www.excelforum.com/member.php...o&userid=36952
> View this thread: http://www.excelforum.com/showthread...hreadid=566608
>

Then again, maybe not. Sorry

"Beege" <[email protected]> wrote in message
news:[email protected]...
> Richard
>
> Maybe....
>
> ="\"""&A1&"\"""
>
> will help
>
> Beege
>
> "richard354" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> 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.
>>
>>
>> --
>> richard354
>> ------------------------------------------------------------------------
>> richard354's Profile:
>> http://www.excelforum.com/member.php...o&userid=36952
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=566608
>>
>
>