ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting to ASCII Txt Doc without Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/150167-exporting-ascii-txt-doc-without-tabs.html)

[email protected]

Exporting to ASCII Txt Doc without Tabs
 
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?


David Biddulph[_2_]

Exporting to ASCII Txt Doc without Tabs
 
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).
--
David Biddulph

wrote in message
ups.com...
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?




Bernard Liengme

Exporting to ASCII Txt Doc without Tabs
 
Follow David's advice - in the Save As dialog look for Formatted text (space
delimited)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
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?




[email protected]

Exporting to ASCII Txt Doc without Tabs
 
On Jul 13, 2:26 pm, "Bernard Liengme"
wrote:
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

wrote in message

ups.com...



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?- Hide quoted text -


- Show quoted text -


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


Earl Kiosterud

Exporting to ASCII Txt Doc without Tabs
 
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...
-----------------------------------------------------------------------
wrote in message
ups.com...
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?





All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com