Claire has attended:
Excel Intermediate course
Excel Advanced course
Maximum Characters in one cell
I regularly have to add large paragraphs of text into one cell. When I have entered a lot of text its goes a bit wierd and the text stops wrapping. I know on MS access you can set the number of characters you can input into a cell. Can you do something similar in MS Excel?
RE: Maximum Characters in one cell
Hi Claure, thanks for your query. There is an upper limit on the amount of information you can display in a cell:
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
Hope this helps,
Anthony
RE: Maximum Characters in one cell
Hello friends.. thanks a lot telling us this, this is a very good thread for me.
One cell in Excel can hold 32,767 characters.
The maximum you can see in a cell on the worksheet is 1,024, but
all 32,767 are shown in the formula bar.
Term Papers
