Hi,
when I want to save the excel file as the prn file in the condition: the
width of the excel file exceed one page and when save into prn all the field
that fall under the exceeded page will appear at the bottom in prn file.
for example below. x12, x654, x323 suppose to be on the same line with the 3
records.

aa 12345 american road 102.20
gg 456 werndtr road 3478.90
rr 76777 hamilton road 8345.70
x12
x654
x323

Saved from a previous post:

There's a limit of 240 characters per line when you save as .prn files.

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(" ",5),5) & LEFT(B1&REPT(" ",4),4) & TEXT(C1,"000,000.00")

(You'll have to modify it to match what you want.)

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=015...0a% 40phx.gbl

AskExcel wrote:

Hi,
when I want to save the excel file as the prn file in the condition: the
width of the excel file exceed one page and when save into prn all the field
that fall under the exceeded page will appear at the bottom in prn file.
for example below. x12, x654, x323 suppose to be on the same line with the 3
records.

aa 12345 american road 102.20
gg 456 werndtr road 3478.90
rr 76777 hamilton road 8345.70
x12
x654
x323

--

Dave Peterson