Exporting to ASCII Txt Doc without Tabs

  • Thread starter Thread starter durstbj
  • Start date Start date
D

durstbj

This is an easy one that I can't remember how to do. How do you save
so that there arent any tabs between columns?
 
What do you want to use to separate the columns? To use commas, save as
CSV. To separate by spaces, save as space delimited text (.prn).
 
Follow David's advice - in the Save As dialog look for Formatted text (space
delimited)
best wishes
 
Follow David's advice - in the Save As dialog look for Formatted text (space
delimited)
best wishes
--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email






- Show quoted text -
Click to expand...

I don't want anything between the columns... Thats what I can't figure
out.
 
Durst,

Try the Text Write Program at www.smokeylake.com/excel. You can specify any character, or
no character, for the field delimiter. It's interactive -- you don't have to deal with any
code.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top