Narrative in cells

[Jane]

Sometimes when putting narrative into cells the text
disappears, even wehn increasing the size of the cell
both vetically and horizonatally this continues to
happen, has anyone else experienced this and if so is
there a way around it or is simply because I trying to
put too much narrative into one cell.

Thanks

Jane

 

[Gord Dibben]

Jane

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots.

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

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.

.........End Dave P.................

Failing that, use a Text Box to store the text.

Gord Dibben Excel MVP