Thanks, Tom.

I knew about alt-enter, so should have mentioned it... OTOH, I try
never to encourage people to use XL as a word processor.


In article ,
"Tom Ogilvy" wrote:

Just so you don't become Harlan bait, someone discovered that if you
manually go into the text and do hard returns (alt+enter) throughout your
data then reduce the font and stretch the cell to its limits you can get
double digit thousands of characters to display. I first saw Dave Peterson
post this (but don't know if he was the original source or Harlan or someone
else was), but then recently saw a long tirade by Harlan about how MS
doesn't have accurate help blah blah blah.

Of course they demo this with a REPT formula which has a lot of practical
application. Personally, I don't see myself hand formatting cells with 32K
characters, but they are technically correct.