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 réponse

Réponse 1 / 1
michel_m Posted messages 18903 Registration date   Status Contributeur Last intervention   3 320
 
Hello
=NBCAR(A1)-NBCAR(SUBSTITUTE(A1,"a",""))

--
Michel
11
Fafam
 
Super !! Thanks
0