The LEN function counts the amount of characters in a cell. For example:
=LEN(A3)
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.
A cell can hold up to 32,767 characters, of which only 1024 can be seen in the cell.
It depends on the length of each word. The number of words does not matter; the limit is the number of total characters, including spaces. The maximum length of cell contents (text) is 32,767 characters. Only 1,024 display can display in a cell, but all 32,767 characters display in the formula bar.
In Microsoft Excel 2007, Total number of characters that a cell can contain is 32,767 characters. Source: Microsoft Office Website Check related link..
Use the LEN function to count how many characters are in the cell. If you want to evaluate cell C23, use LEN(C23)=6.
256
32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.32767 characters per cell are allowed. 1024 displayed characters can appear on the cell, and all on the formula bar. There is a maximum column width of 255 characters. You will see more than 255 characters if there is sufficient number of empty cells to the right.
255
8
Like all modern applications Excel has the capability to show things in various colours, so it can display characters in many colours.
255
Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting