Count how many times letter found

Found this in an old file while doing some digital cleaning

This will show you how you can easily count how many times a letter (or any string) into a cell.
So the main formula doing that is …


Of course, this assumes you are looking to find how many the letter “O” is found. one letter


If you are looking to count how many times a word (more than 1 letter) you need to adjust that


Too count for “OM”, notice that the 2 at end is the number of characters you are looking to count for

You may sure adjust that to cover more options, or dynamic, the idea is as below…

We count the length of the string, then we subtract it from the length of it after we replace all strings found


Does that make sense?