View Single Post
  #4   Report Post  
Martin
 
Posts: n/a
Default Display text 1024 characters in a cell

Can the alt enter linebreaks be inserted by formula - say after every period,
or do they have to be manually inserted. If they have to be manually
inserted is there another solution?
--
Martin


"RagDyeR" wrote:

Don't know the actual maximum that can be displayed, but inserting
appropriately placed forced line breaks ( <Alt <Enter ) can display in
*excess* of 5000 characters.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Martin" wrote in message
...
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