=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

--

HTH

RP

"Rajesh Kamath" wrote in message
...
Hi,

Can someone help me,

my issue is, if for example there is text entered in one cell like
"aabcd" .I want to count the number time "a" appearing in the cell.

Thanks

Rajesh Kamath