count a character

  • Thread starter Thread starter hsg
  • Start date Start date
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
 
Try this...

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

Case being equal: L and l are the same
 
Back
Top