Text not wrapping within a cell

[Frank D. Nicodem, Jr.]

I have a column of cells that have been set to "Wrap Text". For most cells,
it works just fine. But in a few cases, there is a lot of text within the
cell. And when that happens, I see the first dozen or so lines of text
doing an automatic "wrap"... but then the rest of the cell does not wrap!

It almost seems like there is some "magic maximum length" for wrapping,
after which the text will no longer wrap. When I cut the single cell into
multiple cells, it once again wraps correctly!

Is this an anticipated result? And is there anything I can do to get longer
cells to continue wrapping? I've tried AutoFit, and Wrap Text, and a few
other formatting options, all with the same result. (FWIW, I've even tried
merging multiple vertical cells into a single cell, but the Wrapping quits
at exactly the same place.) No text gets "lost"; it's all still there.
Only the Wrapping stops.

 

[Gord Dibben]

Frank

Perhaps it quits wrapping because you have reached the cell limit for
characters.

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, about every 100 characters..

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 or MS Word which is a word
processing application, unlike Excel which is not.


Gord Dibben Excel MVP

I have a column of cells that have been set to "Wrap Text". For most cells,
it works just fine. But in a few cases, there is a lot of text within the
cell. And when that happens, I see the first dozen or so lines of text
doing an automatic "wrap"... but then the rest of the cell does not wrap!

It almost seems like there is some "magic maximum length" for wrapping,
after which the text will no longer wrap. When I cut the single cell into
multiple cells, it once again wraps correctly!

Is this an anticipated result? And is there anything I can do to get longer
cells to continue wrapping? I've tried AutoFit, and Wrap Text, and a few
other formatting options, all with the same result. (FWIW, I've even tried
merging multiple vertical cells into a single cell, but the Wrapping quits
at exactly the same place.) No text gets "lost"; it's all still there.
Only the Wrapping stops.

Gord Dibben MS Excel MVP