Thread: format cells to display 20 long sentences in a single cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default 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.

Reply With QuoteReply With Quote