How to print 2000+ characters seen in formula bar?

E

Excel 2003

I have more than 1024 characters in one cell. I can see the complete text in
the formula bar but I cant print it
 
J

Jim Rech

Actually a cell can only display a maximum of about 1000 characters. It's
just a limitation in Excel. (Frank knows this but he's tired from not
sleeping for the last 6 months<g>).

--
Jim Rech
Excel MVP
|I have more than 1024 characters in one cell. I can see the complete text
in
| the formula bar but I cant print it
 
D

Dave Peterson

I put this in A1 of a test workbook:
="yyy"&CHAR(10)&REPT(REPT("asdf ",40)&CHAR(10),30)&"xxx"
(set it for wraptext and changed it to a value.)

Adjusted the columnwidth and rowheight (autofit didn't work) and saw all
6037 characters in the cell and in printpreview. (I didn't actually test
printing.)
 
Top