count a character

H

hsg

How can we count the number of times a character is appearing in a cell, i.e.
if I enter a text in a cell, how many times "L" is appearing in it?

thanks in advance
 
T

T. Valko

Try this...

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

Case being equal: L and l are the same
 
Top