Printing Long Records To File

  • Thread starter Thread starter Morris Benjamin
  • Start date Start date
M

Morris Benjamin

Does anyone know how to print records longer than 256
characters to an output file without wrapping?

Thank you in advance for your assistance.
 
(.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]
 
Thank you.
-----Original Message-----
(.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=015b01c32c5f$b3d398d0% 24a501280a%40phx.gbl



--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
Back
Top