When you need to count the characters in cells, use the LEN function. The function counts letters, numbers, characters, and all spaces. For example, the length of It's 98 degrees today, so I'll go swimming (excluding the quotes) is 42 characters—31 letters, 2 numbers, 8 spaces, a comma, and 2 apostrophes.
https://support.office.com/en-us/article/Count-characters-in-cells-1BE151D7-5B8F-4186-87B9-7B0318583163
To use the function, enter =LEN(cell) in the formula bar and press Enter. In these examples, cell is the cell you want to count, such as B1. To count the characters in more than one cell, enter the formula, and then drag the fill handle across or down the range of cells you want to use. To count a total number of characters in several cells, use the SUM functions along with LEN. For example, =SUM((LEN(cell1),LEN(cell2),(LEN(cell3)))) . In this example, the LEN function counts the characters in each cell and the SUM function adds the counts.
https://support.office.com/en-us/article/Count-characters-in-cells-1BE151D7-5B8F-4186-87B9-7B0318583163
In this formula A1 is the cell where the number of text characters will be calculated. The point is Excel has character limitations. For example, the header cannot exceed 254 characters. If you exceed the maximum, the header will be cut.
https://www.ablebits.com/office-addins-blog/2015/02/19/excel-count-text-characters/
To edit cells with long text expand the formula bar (. +. +. ). If you just need to display an extract from the cell, you can use a formula like this to display up to the first 10 characters: where: 1  A1 is the cell with your long text. 2  10 is the maximum number of characters you want to show.
http://superuser.com/questions/65556/excel-displays-for-long-text-whats-wrong
We've got an excel sheet with a pretty long text in one cell. Instead of line breaks (as set in the cell format), we get a long line of #### s. We can go back and forth by deleting and adding chars at the end of the text. We've played around with cell formatting etc. but no success.
http://superuser.com/questions/65556/excel-displays-for-long-text-whats-wrong
Excel-Count cells with text. If you need to count the number of cells with text in Excel, you can use the COUNTIF function: =COUNTIF(A2:D10,*). Here A2:D10 is your range with data and * is a wildcard matching any number of characters.
https://www.ablebits.com/office-addins-blog/2015/02/19/excel-count-text-characters/
On Sheet1 of this sample workbook, click cell B2. In the cell, enter =LEN(A2) and press Enter. The formula counts of the characters in cell A1, 45, and that number includes all spaces. If you have spaces after the final period, the formula also counts them.
https://support.office.com/en-us/article/Count-characters-in-cells-1BE151D7-5B8F-4186-87B9-7B0318583163
The following array formula (must be entered with Ctrl+Shift+Enter) will help you count the number of occurrences of certain text in a range: =SUM((LEN(C2:D66)-LEN(SUBSTITUTE(C2:D66,Excel,)))/LEN(Excel)). For example, you can count the number of times the word Excel is entered in your table.
https://www.ablebits.com/office-addins-blog/2015/02/19/excel-count-text-characters/
If you have worksheets with large amount of text in several cells, you may find the following information helpful. The point is that Excel has a limitation on the number of characters you can enter to a cell. 1  Thus, the total number of characters that a cell can contain is 32,767.
https://www.ablebits.com/office-addins-blog/2015/02/19/excel-count-text-characters/
Excel displays ### when the cell content contains just text and it exceeds 256 characters and the cell format is set to  Text . Usually, setting the cell format to .
http://superuser.com/questions/65556/excel-displays-for-long-text-whats-wrong
how many characters can be in an excel cell
An excel cell can contain 256 characters. There are 256 characters in an excel cell.