Wrap text

[Kevmanley]

Text wrap works fine until I get to the 15th line of the cell and then it
doesn't work. I've tried retyping but to no avail. Is there a wrap text limit
or extent settings?

 

[FSt1]

hi
in xl help type the word specifications. this will give you the
specifications on your version of excel.
speaking of 2003 and earlier. no limit on wrap(by name) but there is a limit
to what will show in the cell. 1024 characters. the limit is 37767 which will
show in the formula bar on only 2024 will show in the cell.
not sure if this is your problem or not.

regards
FSt1

 

[Dave Peterson]

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you should be able to see more characters.

 

[Dave Peterson]

I bet you meant 1024 instead of 2024 and 32,767 instead of 37767 in your
message.

But that "documented in help" number can be greatly exceeded by adding
alt-enters every 80-100 characters.

 

[FSt1]

hi
yep you're right.
accursed foul memory. or was it accursed foul typo.

thanks for catching that.
regards
FSt1