Found this in an old file while doing some digital cleaning<\/p>\n
This will show you how you can easily count how many times a letter (or any string) into a cell.
\nSo the main formula doing that is …<\/p>\n
=LEN(I12)-LEN(SUBSTITUTE(I12,\"o\",\"\"))<\/pre>\nOf course, this assumes you are looking to find how many the letter “O” is found. one letter<\/p>\n
<\/p>\n
If you are looking to count how many times a word (more than 1 letter) you need to adjust that<\/p>\n
=LEN(I12)-(LEN(SUBSTITUTE(I12,\"om\",\"\")\/2))<\/pre>\nToo count for “OM”, notice that the 2 at end is the number of characters you are looking to count for<\/p>\n
You may sure adjust that to cover more options, or dynamic, the idea is as below…<\/p>\n
We count the length of the string, then we subtract it from the length of it after we replace all strings found<\/p>\n
<\/p>\n
Does that make sense?<\/p>\n","protected":false},"excerpt":{"rendered":"
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…<\/p>\n