# 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
|