Exporting to ASCII Txt Doc without Tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

durstbj@gmail.com - 13 Jul 2007 20:30 GMT

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?

Reply to this Message

David Biddulph - 13 Jul 2007 21:08 GMT

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).

Signature

David Biddulph

> 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?

Reply to this Message

Bernard Liengme - 13 Jul 2007 21:26 GMT

Follow David's advice - in the Save As dialog look for Formatted text (space
delimited)
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 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?

Reply to this Message

durstbj@gmail.com - 13 Jul 2007 21:41 GMT

On Jul 13, 2:26 pm, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:

> Follow David's advice - in the Save As dialog look for Formatted text (space
> delimited)
[quoted text clipped - 11 lines]
>
> - Show quoted text -

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

Reply to this Message

Earl Kiosterud - 14 Jul 2007 22:08 GMT

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.

Signature

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...
-----------------------------------------------------------------------

> 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?

Reply to this Message