| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ascii conversion | Excel Discussion (Misc queries) | |||
| Ascii in a cell | Excel Discussion (Misc queries) | |||
| ASCII files ...please help | Excel Discussion (Misc queries) | |||
| Problem with exporting xls sheels to txt files separated by tabs | Setting up and Configuration of Excel | |||
| Exporting Excel Charts in Separate Tabs | Excel Discussion (Misc queries) | |||
Hybrid Mode
