Export (or save as) .csv with text delimiters

[CarolineP]

Has anyone found a way of coercing Excel 2000 to export .csv files with delimiter text? e.g: as "Mickey Mouse","Minnie Mouse","Donald Duck" not Mickey Mouse,Minnie Mouse,Donald Duck

Thanks

Caroline

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom

"CarolineP" <[email protected]> wrote in message
news:[email protected]...
>
> Has anyone found a way of coercing Excel 2000 to export .csv files with
> delimiter text? e.g: as "Mickey Mouse","Minnie Mouse","Donald Duck"
> not Mickey Mouse,Minnie Mouse,Donald Duck
>
> Thanks
>
> Caroline
>
>
> --
> CarolineP
> ------------------------------------------------------------------------
> CarolineP's Profile:
http://www.excelforum.com/member.php...o&userid=20007
> View this thread: http://www.excelforum.com/showthread...hreadid=345941
>

[Dave Peterson]

And another alternative:

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

has options built into that do what you want (right out of the box).

CarolineP wrote:
>
> Has anyone found a way of coercing Excel 2000 to export .csv files with
> delimiter text? e.g: as "Mickey Mouse","Minnie Mouse","Donald Duck"
> not Mickey Mouse,Minnie Mouse,Donald Duck
>
> Thanks
>
> Caroline
>
> --
> CarolineP
> ------------------------------------------------------------------------
> CarolineP's Profile: http://www.excelforum.com/member.php...o&userid=20007
> View this thread: http://www.excelforum.com/showthread...hreadid=345941

--

Dave Peterson