Gives the answer 2 (not the 3 which the OP wanted) because SUBSTITUTE is
case-sensitive. You need a LOWER.
--
David Biddulph

"Gary''s Student" wrote in message
...
=LEN(A1)-LEN(SUBSTITUTE(A1,"m",""))

--
Gary''s Student - gsnu200764


"nishad" wrote:

I would like to count the no of times a specific letter occurs in a text
string.
For eg if "My name is Amit" is in cell A1. I want to count the no of
times
"m" occurs in A1, which is '3'. Plz help.