I have another instance that I need help with.
I have a string of letters in 1 cell and I want to count how many time a
letter occurs in that cell and eventually count all occurances of al letters
in that one cell. Any ideas?
As an example:
A1 contains "catgctagccatgca" as text. I want to know many times a, c g,
and t occurs in that string.
Say your string is in cell A1
in cells A3 downwards enter the letters of the alphabet:
a
b
c
d
etc.
Uppercase too if you want. Or just the specific letters you're lookin
for.
Then in cell B3 enter this formula:
=LEN($A$1)-LEN(SUBSTITUTE($A$1,A3,""))
and copy down the column.
This is case sensitive.
To make it case insensitive use:
=LEN($A$1)-LEN(SUBSTITUTE(UPPER($A$1),UPPER(A3),""))
instead.
DNA sequencing?
