function to count a certain character in cell
How to use LEN function in Excel to count characters in a cell Count a total number of characters in several cells. The most obvious way to get the total number of characters in several cells is add up a few LEN functions, for example: =LEN(A2)+LEN(A3)+LEN(A4) Or, use the SUM function to total the character counts returned by LEN formulas: