So having found how many there are in one cell, we'll leave it as exercise
for the interested reader to work out how many there are in whichever range
of cells you are interested in.
--
David Biddulph

"Christopher Naveen" wrote in
message ...
HI David,

Thank u very much. I got it and i requested to check for Nos. also. I
tried
the same formula for Nos. but it is not working. Pls advise.

Ex : 56566665
56566666
Ans : 5

If i want to know how many 5's are ther in that 2 cells what formula shud
i
apply?

"David Biddulph" wrote:

=LEN(A2)-LEN(SUBSTITUTE(A2,"A",""))
--
David Biddulph

"Christopher Naveen" wrote
in
message ...

... Also pls tell me how can we find that how
many A's i have in a cell,

Ex :

AAAABBN
AHHH
AQREE
AA
....