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

--
Regards,
Luc.

"Festina Lente"


"FlipperT" wrote:

I work in a genetics lab and would like to know of a function that will count
the nucleotide designators within a cell. Say I am ordering a primer, and
have this sequence in a cell: ataacgctttaggg Is there a function that will
tell I have 4 'a's in that cell. Or is there a function that will tell me
that I have 6 (c's and g's) in the cell.