count number time character appears in Excel
Q13. Can I determine the number of times a character appears in a cell using formula?
For example, I want to get the number of times the character "s" appears in cell C21 that has text "assessment".
To do it in Excel, here is the answer:
a) Enter the formula =LEN(C21)-LEN(SUBSTITUTE(C21,"s","")) in the cell where the result is required.
The SUBSTITUTE formula removes all "s" in "Assessment" and stores the result as a string in memory. The difference in length of the original string and the length of this modified string in memory is the number of times the character
"s" appears in original string.