how to convert xls file into delimited txt file

[PJY]

I need to convert two files. Both from .xls. One into a delimited file with
~ and one with |.

 

[Bob I]

Perhaps do a find and replace , to ~ using Notepad after you save as CSV?

 

[Dave Peterson]

You could modify your windows regional settings (list separator) (twice!) and
then save as the .csv files.

Or...

Maybe you could write your own exporting program that would behave exactly the
way you want:

Here are three sites that you could steal some code from:

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

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste into Notepad.)

Check out Earl's Text Write program first. It may do exactly what you want
right out of the box.