format cells to display 20 long sentences in a single cell
 

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.

format cells to display 20 long sentences in a single cell
 

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
DTHIS
www.nickhodge.co.uk


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

format cells to display 20 long sentences in a single cell
 

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

r wrote:

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.

--

Dave Peterson