Saving as text file

  • Thread starter Thread starter eshwar
  • Start date Start date
E

eshwar

Hi,
I need to save excel file as text file. The problem is i need tex
file delimited with ~ (tilda). when i do save as, i am getting tex
file with huge spaces. how can i do this?

Thanks in advance.
Eshwar
 
One way is to change a windows setting.

In win98:
windows start button|settings|control panel|regional settings applet
Number tab|list separator (change to tilde)

Apply and do File|save as|CSV (comma separated)

Remember to change it back when you're done!

Or maybe you could write your own macro to do exactly what 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

(You may be happy with Earl's version--right out of the box!)
 
Dave,

I changed that page to www.smokeylake.com/excel/Text_write_program.htm a
while back. The %20 was messy.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Dave Peterson said:
One way is to change a windows setting.

In win98:
windows start button|settings|control panel|regional settings applet
Number tab|list separator (change to tilde)

Apply and do File|save as|CSV (comma separated)

Remember to change it back when you're done!

Or maybe you could write your own macro to do exactly what 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

(You may be happy with Earl's version--right out of the box!)
Click to expand...
 
The links work with lowercase characters, but (from someone who speaks no HTML)
isn't there a way to make it case insenstive--completely?

(Ps. I've updated my links again. <vbg>)

Earl said:
Dave,

Thanks. Sheesh. I know better. I've changed it to text_write_program.htm.
Click to expand...
 
Back
Top