Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Text in CellsPosted 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?
Re: Text in CellsPosted 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.
Re: Text in CellsPosted by Jack in UK on January 14, 2002 11:10 AM
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.
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.
Re: Text in CellsPosted 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.
Re: Text in CellsPosted 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.
Re: Text in Cells - TOMPosted 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!)
Re: Text in Cells - TOMPosted 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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.