how to count characters in a cell

B

Bill in Verona, WI

Is there a non-vba formula to count specific characters in a cell? (ie
A1=BILL, B1 shows the result 2 for a formula counting L's in A1)

Thank you
 
A

Andy Brown

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

Or, if mixed case, Dave Peterson says

=LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),"l",""))

Rgds,
Andy
 

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

How do I count the Characters in a cell 5
Excel Need Countifs Formula Help 0
Count specific characters in a cell 7
Count Text Characters in cell 1
Counting 'up' rows instead of down 1
Count of numerical values within a cell 5
Problem with COUNT 4
Event Counter 1

Top