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
HTH
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.
Vicki
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.
Tom
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!)
ta
Chris
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.
Tom
