word wrap ceases after 1200 characters

  • Thread starter Thread starter Jeff2004
  • Start date Start date
J

Jeff2004

Word wrap appears to cease after about 1200 characters.
It appears that I am running into some kind of length
limit, but I do not know what that limit is.

(1) Does anyone know the nature of this limit?
(2) Does anyone know a way around it?

Here is the text I put into the cell, changed for
security purposes (word wrap ceases when I get to the
string with g's):
aaaaaaaa aaaaaaaaaa aaaaaaaaaaa aaaaaaaaaaa aaaaaaaaaaaa
aaaaaaaaaa aaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaa aaaaaaaaa
aaaaaaaaaaaaa aaaaaaaaaaaaa aaaaaaaaaaaa aaaaaaaaaaa
aaaaaaaaaaa aaaaaaaa
bbbbbbbbb bbbbbbbbbb bbbbbbbbbbbb bbbbbbbbbbb
bbbbbbbbbbbbb bbbbbbbbbb bbbbbbbbbbbb bbbbbbbbbbbbb
bbbbbbbbbb bbbbbbbbbb bbbbbbbbbbbb bbbbbbbbbbb bbbbbbbbb
bbbbbbbbbbb bbbbbbbbbbbb bbbbbbbbbbb bbbbbbbbbbb
bbbbbbbbbb
ccccccccc cccccccccc ccccccc ccccccccc cccccccccc
ccccccccc cccccccccc cccccccccc cccccccccccc ccccccccc
ccccccccccc cccccccc cccccccccc cccccccccc ccccccc
ccccccc cccccccccccc cccccccccc ccccccccc
dddddddddd dddddddddd dddddddddd ddddddddddd ddddddddddd
ddddddddddddd ddddddddddd ddddddddd ddddddddd
dddddddddddddd ddddddddddd ddddddddddd dddddddddd
ddddddddd dddddddddddd dddddddd dddddddd
eeeeeee eeeeeeee eeeeeeeeee eeeeeeeeee eeeeeeeeeeee
eeeeeeeee eeeeeeeeee eeeeeeee eeeeeeee eeeeeeeeee
eeeeeeeeee eeeeeeeeee eeeeeeeee eeeeeeee eeeeeeeeee
eeeeeee eeeeeee eeeeeeee eeeeeeeeee eeeeeeeeeee eeeeeeeee
eeeeeeee eeee
ffffffff ffffffff ffffffff ffffffffff ffffffffff
ffffffffff ffffffffff ffffffffffff fffffffffff
ffffffffffff fffffffff ffffffff ffffffff ffffffff
ffffffffff ffffffffff ffffffffff gggggggg hhhhhhhhhhh
iiiiiiiiiiiiiiiiii jjjjjjjjjjjjjj kkkkkkkkkkkkk llllllllll
 
Excel's help says that you can have about 32k characters in a cell, but only
about 1000 will appear in that cell (all 32k will appear in the formula bar,
though).

But if you add a few alt-enters to your text, then you can see more. (You might
have to resize the rowheight manually, though.)

I copied your sample text into a text editor and removed all the carriage
return/line feeds (from the newsgroup post). I had the same problem as you
said.

But if I just copied from the post (and kept those CRLF's), then after I
increased the rowheight, I could see everything.
 
Thanks for looking into this. It did not quite work for
me, the way I understood your response. I put an Alt-
Enter after the a's, another after the b's, etc. but the
final line of the cell still did not wrap into the cell
contents displayed. Also, with all the Alt-Enters, I do
not see the bottom text because I run into the maximum
row height (409 pixels), unless, of course, I widen the
column. I may just content myself with not having all the
data visible, since the additional line feeds would
expand the cell area taken up by the text anyway, and I
want to keep things sort of compact.
 
You could widen the column, change the font size, and only use alt-enters at
judicious locations.

But, yeah, there's limitations on almost everything.
 
Back
Top