Try...

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

....which is case-sensitive. If you don't want it to be case-sensitive,
try the following instead...

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

or

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

....where B1 contains the letter of interest.

Hope this helps!

In article ,
"PCLIVE" wrote:

Is there a function that I can use to determine the number of times the
letter "Y" appears in a single cell?

Thanks,
Paul