Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
CarolineP
 
Posts: n/a
Default Export (or save as) .csv with text delimiters


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

  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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

--

Regards,

Peo Sjoblom

"CarolineP" wrote in message
...

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



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 6 April 2nd 23 08:33 PM
How To Import Text File With No Delimiters? Sam Excel Discussion (Misc queries) 1 February 8th 05 05:54 PM
Export to fixed width text file FinChase Excel Discussion (Misc queries) 0 January 24th 05 07:25 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
How do I get carriage returns to not be row delimiters in text fi. RV Excel Discussion (Misc queries) 1 December 16th 04 11:47 PM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"