Excel (Exporting to *.txt) via fixed format

[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

 

[Dave Peterson]

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]