how to count characters in a cell

  • Thread starter Thread starter Bill in Verona, WI
  • Start date Start date
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
 
=LEN(A1)-LEN(SUBSTITUTE(A1,"L",""))

Or, if mixed case, Dave Peterson says

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

Rgds,
Andy
 
Back
Top