98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Maximum Characters in one cell
Maximum Characters in one cell
Resolved · Medium Priority · Version 2003
Wed 1 Sep 2010, 10:18Delegate Claire said...
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?
Wed 1 Sep 2010, 13:51Trainer Anthony said...
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
Thu 2 Sep 2010, 08:58Delegate Mike said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Paste a web address into the hyperlink address fieldIf you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work. |
