Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving to .txt
I'd like to be able to copy excel to .txt and keep columns aligned. I can
Save As... to .txt and the columns are somewhat aligned but not totally. Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving to .txt
Like a fixed width file?
Try saving it as a "formatted text (space delimited)(*.prn)" file. and ... Saved from a previous post: (.prn files will wrap after 240 characters) You have a few choices (try against a copy of your worksheet): I'd either concatenate the cell values into another column: =LEFT(A1&REPT(" ",20),20) & LEFT(B1&REPT(" ",10),10) & TEXT(C1,"000,000.00") Then I'd copy and paste to notepad and save from there. Once I figured out that ugly formula, I kept it and just unhide that column when I wanted to export the data. If that doesn't work for you, maybe you could do it with a macro. Here's a link that provides a macro: http://google.com/groups?threadm=015...0a% 40phx.gbl grok wrote: I'd like to be able to copy excel to .txt and keep columns aligned. I can Save As... to .txt and the columns are somewhat aligned but not totally. Is there a way to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automation autosave .xls as .txt | Excel Worksheet Functions | |||
Slow saving when adding VBA forms | Excel Discussion (Misc queries) | |||
Saving worksheet as webpage | Excel Discussion (Misc queries) | |||
Saving Excel 2003 file in .txt format | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) |