Hi All,

I need a formula to find the occourance of a text in a cell.

for Example: In cell there is a text "Rarrurrlas" i want to find the number occourance of "rr" in the given text.

and ans should be : 2

I am using below formula: =LEN("Rarrurrlas")-LEN(SUBSTITUTE("Rarrurrlas","rr",""))

but it is giving me ans : 4

Thanks
Rahul Kumar Singh