Excel (Exporting to *.txt) via fixed format

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

Hello,

How do I export a excel file to a text (fixed format)
file? Also, How can you maintain the size of char's for
each column? Any assistance would be helpful...Thanks
 
You mean you want to see the characters in non-proportional font?

If yes, ctrl-A and use a font of Courier New.

===

For the fixed width export:

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]
 
Back
Top