Delimiters

[Dan St. G]

is there any way to specify a delimiter instead of taking
the default "Tab" or "comma"? Example: I want the
delimiter to be "~" between each field when I save as a
text file.

 

[jr]

copy the table to WORD as a table. Then use:
TABLE | CONVERT | TABLE TO TEXT
you'll be prompted for a delimiter.

 

[Dave Peterson]

Another way is to use Earl Kiosterud's Text Write program. It's available at:

It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Earl has a bunch of options that you can specify.

And you may want to look at Chip Pearson's code (if you ever want to write your
own):

http://www.cpearson.com/excel/imptext.htm