Count the occurrences of text, characters, or words in Excel

[stanleydgromjr]

littleiitin,

Try:

In A1:
Rarrurrlas

In B1:
=(LEN(A1)-LEN(SUBSTITUTE(A1,"rr","")))/2
The result in B1 would be:
2


The last number in the formula, the 2, is the actual length of the string rr that you are searching for.
=(LEN(A1)-LEN(SUBSTITUTE(A1,"rr","")))/2



If cell A1 contained:
RarruXXlas

And cell B1 containd the same formula:
=(LEN(A1)-LEN(SUBSTITUTE(A1,"rr","")))/2

The result in B1 would be:
1



Have a great day,
Stan