format cells to display 20 long sentences in a single cell

[Guest]

Even if i format the cell (in exel sheet) as wrap text, the cell does not
display long sentences completly. It only displays a part of the sentence.
This happens after entering say 20 or more lines.

 

[Nick Hodge]

r

From help

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

You could use a text box if this helps

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Dave Peterson]

If you add alt-enters every 80-100 characters to force new lines within the
cell, you'll see lots more characters.