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

  • Highlight/Color Negative Value In Excel

    This post demonstrates how to highlight/color negative values in excel. By highlighting negative values in color we enable those values […]

    Share The Knowledge
  • Find Asterisk In Excel

    In this post we  will learn about how to find asterisk in excel.We may find some special character and wildcard […]

    Share The Knowledge
  • Highlight Blank Cells In Excel

    Let’s see how to highlight all the cells in a sheet in excel that contains blank. We are often come […]

    Share The Knowledge
  • Add One/N Month To Date In Excel

    In this post we will see how we could advance a date by one/n month in excel. In several day […]

    Share The Knowledge

Leave a Reply