MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text in Cells

Posted by Vicki on January 14, 2002 11:03 AM

When trying to add a lot of text to a cell, once I reach a certain point the end of the text will not display no matter how big I make the cell.

Does anyone know how this can be resolved?

Posted by Kristy on January 14, 2002 11:06 AM

You can try setting the cell to wrap the text. Go to Format, Cells, Alignment, and click Wrap Text.

Or, to do it manually, press alt+enter when you want to make a new line.

Posted by Jack in UK on January 14, 2002 11:10 AM

Hi Vikki--

Sadly must to my dispare Excel limits to 256 character including spaces, characters and symbols, can be broken in to many line in that single cell then --- wont take no more like a pint hold a pint and no more. some times im forced to COMMENT box in cells older history, but thats a problem with Vlookups .

Excel has limits, not that we like them, font size or box size wont help.

Sorry, if any one knows a fix, i for sure could do with a pointer.
Take care
JAck in UK

PS after thought i have also added an olde notes cell some 3 or 4 to the right on my table array, so i can see historical notes.. Its a pain thou, bit can help.

Posted by Vicki on January 14, 2002 11:10 AM

I have wrapped the text and it will wrap but it seems as though there is a limit to the characters I can use.


Posted by Tom Morales on January 14, 2002 11:13 AM

Vicki - Sadly, Excel has the following limits for cell entries. The Length of cell contents (text)is 32,767 characters, BUT only 1,024 display in a cell. All 32,767 display in the formula bar.

Posted by Chris D on January 15, 2002 10:59 AM

Hi Tom, those 1,024 - off the top of your head is that still the limit if cells are merged ?

(not particularly wanting to test it right now and count them all!)


Posted by Tom Morales on January 17, 2002 11:22 AM

Chris - I'd bet money the answer is yes, but wouldn't stake my life on it.