Count Occurrences Of A Character In Excel

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.

Capture

As you see the occurrence is 2.




Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply