Thank you Dave and Gordon - egg on my face. Although I read the message, I
still forgot about the display factor. I will put in the alt-enters.

Thanks for being understanding and still willing to help out someone who
could not 'see the forest through the trees'.

Happy Friday!

"Dave Peterson" wrote:

About 1024 includes spaces. And both 1683 and 1431 are larger than 1024.

You'll want to add those alt-enters every 80-100 characters to see more than
1024 (about) characters.

Jones wrote:

Thank you, Gord - when I counted the characters, it totaled 1683 with spaces
and 1431 without spaces. From the information you provided, my text should
display. I played with the table height, formatting the cells, I am missing
something. I will probably slap my forehead when I hear or figure it out. Do
you have any suggestions?

"Gord Dibben" wrote:

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?



--

Dave Peterson