View original (French)

Count identical characters in Excel cell

Solved
Fafam -  
 Fafam -
Hello,

I would like to count the number of "a" in an Excel cell. I found an example formula on a forum:
In A1: abracadabra
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))
The formula should return 5
But it doesn't work. Please, does anyone have an idea?
Thank you

Configuration: Windows XP / Internet Explorer 6.0

1 answer

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello
    =NBCAR(A1)-NBCAR(SUBSTITUTE(A1,"a",""))

    --
    Michel
    11
    1. Fafam
       
      Super !! Thanks
      0