Counting number of time a character appears in a string
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))
will count the occurrence of a in cell A1, if you have a range with strings
use
=SUMPRODUCT((LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a",""))))
--
Regards,
Peo Sjoblom
"Henrik" wrote in message
...
Does anyone know a way to automatically count how many times a certain
character counts in a text string?
|