count number of specific letters in a word

[ehansen]

Hi mrExcel, I need a way to calculate the numbers of specific letters in a word, in my case a dna sequence.

An example: The word is aaggccttt. I need to get the numbers of a, g, c and t in separate cells. In this case 2,2,2 and 3.

Thanks for your answer,

Erik

 

[Richard Schollar]

Hi Erik & Welcome to the Board

Same principle applies to all letters:

=LEN(A1)-LEN(SUBSTITUTE(A1,"A",""))

amend the red A for the letter of interest