Let’s see how to count the occurrence of a character in text in a cell in excel.
We will write a formula to see the number of occurrences of a particular character.
In the below example we will see how to count the occurrence of “m” in the string “summon”.
Enter the formula =LEN(K7)-LEN(SUBSTITUTE(K7,”m”,””)) in the cell.
As you see the occurrence is 2.
Hope this helped.