If you add some alt-enters (every 80-100 characters), you'll be able to see more
than 1000 characters.



Martin wrote:

Cell B2 contains a narrarrtive - say 5000 characters. The cell will only
display 1024 characters.

I would like to display the first 800 or so characters, ending with a
period, in cell B3.

The next 800 or so characters, ending with a period, in cell B4 and so on
into B5 etc.

This has me stumped. How would this be done and if so can row height be
adjusted by formula?

Thank you,

--
Martin

--

Dave Peterson