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

--
Biff
Microsoft Excel MVP


"hsg" wrote in message
...
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

=LEN(A1)-LEN(SUBSTITUTE(A1,"L",""))
--
David Biddulph

"hsg" wrote in message
...
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