Gord Dibben said:
32767 is the limit.
Note: only about 1024 characters will be shown or printed.
....
Except for text containing regularly spaced newline characters, in small
typesizes, in very wide and tall cells with word wrap enabled. Those cells
easily display over 10,000 characters. Dunno about printing.
Some people prefer parroting online help rather than mentioning how Excel
*really* works. This asertion *can* be checked by anyone more concerned with
what Excel really does than with what Microsoft's seldom if ever
updated/corrected documentation says it does.
At 1024 by 768 resolution, with column width 139 (visible width of Excel
document window while still showing worksheet frame and vertical scroll bar)
and row height maxed out at 409.5, with word wrap enabled, and font Times
New Roman at 4 point typesize, Excel 2K (at least) happily displays all
15,751 characters of the formula
=REPT("-",480)&CHAR(10)&
REPT(" > "&REPT("#",246)&" < "&CHAR(10),58)&REPT("-",480)
both as a formula and the equivalent value entered into a cell as a text
constant. A decimal order and a half magnitude difference between the docs
and what actually can be achieved is a bit more than the fudge factor
mentioned in some KB article I've seen. Or would you claim 15,751 is
approximately equal to 1,024?
