Yes they can.

To enter the text as a formula, with the forced line breaks:

="This is line one."&CHAR(10)&"This is line two."&CHAR(10)&"This is line
three."

The above displays in the formula bar.

In the cell, you'll see small squares in place of the "Char(10)".

This is line one.�This is line two.�This is line three.

Now, you must format the cell to LineWrap in order for the text to display
properly.

<Format <Cells <Alignment tab, and check "LineWrap".
--

HTH,

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

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