Saving to .txt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/[email protected]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

weird characters are displayed 1
Saving as txt file 2
How to export to txt and use "-sign 9
Exporting txt file 1
.txt format issues 1
Export excel file to txt 3
opening txt documents in excell 1
Format .txt file contents to numeric format will not work - help! 3

Back
Top