Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
How To Import Text File With No Delimiters? | Excel Discussion (Misc queries) | |||
Export to fixed width text file | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) |