How to print 2000+ characters seen in formula bar?

C

Curious

Formula bar shows +1024 characters, screen only shows 1024. Printer only
prints 1024. How can I print all?
 
D

Dave Peterson

Add some alt-enters to force new lines within the cell.

Use a smaller font.
Widen the column width
lengthen the row height.
 
D

Dave Peterson

That's too bad.

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.
 
C

Curious

Yes, your formula worked for me too (after changing the commas to semicolons :)
I now see what the problem is. After about 1125 characters, the text stops
wrapping so I see much less text on screen. If you type in your formula and
then adjust the column width to less than the length of the sentence, you
can check if it happens to you too. Why does the wrap stop working? How can
I repair it? I don't want to have to manually type in Alt-enters according
to the width of the cell. I'm posting a new thread on that.
Thanks
 
Top