Saving a worsheet as a fixed-width file

  • Thread starter Thread starter Kyle
  • Start date Start date
K

Kyle

i surrender!!! how can i save a worksheet with multiple
columns as a fiixed width file? There is no option for
fixed-width.
 
You could play around with File|SaveAs
with a filetype = formatted text (space delimited) (*.prn)

But that's limited to 240 characters per line.

If you're going to try, do this against a test copy of your workbook:
ctrl-A
Format|cells|font tab|Courier New

It's a nice fixed width font that'll you see the layout.

===

If you don't like that, 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