Try these:

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),UPPER("R"),""))

=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),UPPER("D"),""))

--
Biff
Microsoft Excel MVP


"Lee" wrote in message
...
If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.