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
|