You can enter 32,767 characters in a cell.

Unfortunately only about 1024 will show or print.

If you add an Alt + Enter every 100 characters you can increase this limit.

BTW...............merging multiple cells does not increase this limit.

You still have one cell.


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 16:36:00 -0700, Jones
wrote:

I have a large amount of text that I am inputting into a merged cell. When I
am editing the text, all the content displays. When I click outside the cell,
only a portion of the text displays. How can I get the entire text to display
in the cell?