# of specific characters in a cell?
 

=len(A1)-len(substitute(A1,"a",""))

will count the number of a's (case sensitive).

If you want it case insensitive

=len(A1)-len(substitute(lower(A1),"a",""))

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
is there a formula that will count the number of times a character appears
in a single cell?

-Chris