text limits

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am trying to enter a large quantity of text in a single
cell and seem to be limited on how much text can be
entered. The first several paragraphs wrap fine, the last
three will not wrap. Is there a way around this?
 
Gary

Excel allows 32,767 characters in a cell but will show or print only 1024.
One workaround is to spread a few ALT + ENTER's at spots. This will increase
the amount shown. Don't know how far this will go.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Gord Dibben said:
Excel allows 32,767 characters in a cell but will show or print only 1024.
One workaround is to spread a few ALT + ENTER's at spots. This will
increase the amount shown. Don't know how far this will go.
Click to expand...
....

FWIW, XL2K displays all 11,804 chars of

="foo"&CHAR(10)&REPT(REPT("----+----#",25)&CHAR(10),47)&"bar"

both as a formula and converted to a text constant. Granted this is at 6
point typesize, cell width 172, height 409.5, screen resolution 1280x1024,
and with word wrap enabled. Still. makes a bit of a mockery of this 'spec'.
 
Back
Top