Here are 5000 or so genes for a bacterial genome listed in my Excell 2007.
There are two columns. col (1) lists the gene names and col(2) lists the
corresponding nucleotides sequence like ATTCGGGG.....

is there a simple way to count the number of nucleotides (characters) in
each cell?

=LEN(A1)

This includes spaces and other non-visible characters.

Regards,
Paul

--

"ty" wrote in message
...
Here are 5000 or so genes for a bacterial genome listed in my Excell 2007.
There are two columns. col (1) lists the gene names and col(2) lists the
corresponding nucleotides sequence like ATTCGGGG.....

is there a simple way to count the number of nucleotides (characters) in
each cell?

=len(a1)
will tell you the length of the string in A1.

=(len(a1)-len(substitute(a1,b1,"")))/len(b1)
will tell you the number of times B1 appears in A1.

ty wrote:

Here are 5000 or so genes for a bacterial genome listed in my Excell 2007.
There are two columns. col (1) lists the gene names and col(2) lists the
corresponding nucleotides sequence like ATTCGGGG.....

is there a simple way to count the number of nucleotides (characters) in
each cell?

--

Dave Peterson

ps. If you want to make the count case-insensitive (ASDF and aSdF and asdf are
all the same):

=(len(a1)-len(substitute(upper(a1),upper(b1),"")))/len(b1)

ty wrote:

Here are 5000 or so genes for a bacterial genome listed in my Excell 2007.
There are two columns. col (1) lists the gene names and col(2) lists the
corresponding nucleotides sequence like ATTCGGGG.....

is there a simple way to count the number of nucleotides (characters) in
each cell?

--

Dave Peterson

Say the nucleotide designator is:
ataacgctttaggg

Use this to count the 'a' characters:
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

Use this to count the 'c' and 'g' characters:
=LEN(A1)*2-LEN(SUBSTITUTE(A1,"c",""))-LEN(SUBSTITUTE(A1,"g",""))

Finally, use this to count all 'a' characters in a range (say A1:A3):
=SUM(LEN(A1:A3)-LEN(SUBSTITUTE(A1:A3,"a","")))
This function needs to be entered with ctrl + shift + enter (not just enter)


Regards,
Ryan---
--
RyGuy


"Dave Peterson" wrote:

ps. If you want to make the count case-insensitive (ASDF and aSdF and asdf are
all the same):

=(len(a1)-len(substitute(upper(a1),upper(b1),"")))/len(b1)

ty wrote:

Here are 5000 or so genes for a bacterial genome listed in my Excell 2007.
There are two columns. col (1) lists the gene names and col(2) lists the
corresponding nucleotides sequence like ATTCGGGG.....

is there a simple way to count the number of nucleotides (characters) in
each cell?

--

Dave Peterson

ty wrote:
Here are 5000 or so genes for a bacterial genome listed in my Excell 2007.
There are two columns. col (1) lists the gene names and col(2) lists the
corresponding nucleotides sequence like ATTCGGGG.....

is there a simple way to count the number of nucleotides (characters) in
each cell?

Note that you should format col (1) as text before loading the data to
prevent some gene names from getting automatically converted into dates.
I mention this because it was a big enough issue a while ago to make
the news (http://www.theregister.co.uk/2004/07...vanishing_dna/)
and a scientific journal (http://www.biomedcentral.com/1471-2105/5/80).