« Macro : Sorting sheets | Main | Advanced Functions: INDIRECT »
March 04, 2005
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";""))
Posted by Dave at March 4, 2005 06:23 PM