Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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?


Re: Text in Cells

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.


Re: Text in Cells

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.


Re: Text in Cells

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


Re: Text in Cells

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

Re: Text in Cells - 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


Re: Text in Cells - TOM

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

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.