Counting letters in a string

To determine the number of occurences of a particular letter in a
string - replace it with a empty character and compare the lenghts
of the original and modified strings.

To find the number of ‘g’s in A1…

=LEN(A1)-LEN(SUBSTITUTE(A1;”g”;”"))

Leave a Reply