Display text > 1024 characters in a cell

[Martin]

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,

 

[Dave Peterson]

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

 

[RagDyeR]

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!
=====================================================

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]

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?

 

[RagDyeR]

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!
=====================================================

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]

Appreciare the input - but i dont think its going to work for me. There is a
workpage in a workbook that contains a narrative. A copy of the workbook and
corresponding narrative is filled out for each customer and then printed out
by different individuals.

Alt Enter requires a lot of editing. Can I enter the narrative in say cell
B2 and cut it up with formulas at the end of stings of about 800 characters
ending in a period. Say the string is 2400 characters long - Conditional
formatting will display the font in cell B2 as white.

Cell b3 has first 800 or so chars
cell b4 has next 800 or so chars
and cell b5 has balance of text


Martin

 

[RagDyeR]

I'm sorry, but I'm having trouble picturing your situation.

I can't fathom any "big" problem in entering, say 10 <Alt> <Enter>'s.

Doesn't this only have to be done once, and thereafter just copied?

--

Regards,

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

Appreciare the input - but i dont think its going to work for me. There is a
workpage in a workbook that contains a narrative. A copy of the workbook
and
corresponding narrative is filled out for each customer and then printed out
by different individuals.

Alt Enter requires a lot of editing. Can I enter the narrative in say cell
B2 and cut it up with formulas at the end of stings of about 800 characters
ending in a period. Say the string is 2400 characters long - Conditional
formatting will display the font in cell B2 as white.

Cell b3 has first 800 or so chars
cell b4 has next 800 or so chars
and cell b5 has balance of text


Martin