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 …

=LEN(I12)-LEN(SUBSTITUTE(I12,"o",""))

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

=LEN(I12)-(LEN(SUBSTITUTE(I12,"om","")/2))

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?

Comments

comments