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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count specific characters in a cell 7
Counting a series of text and/or numbers within columns 17
counting no. of times a character occurs in a cell 3
Help Needed With Count 2
Counting a Specific Character 2
Entering a Text Symbol ? 2
HOW TO COUNT INSIDE A CELL 5
Count 6

Top