hi , i have this in my 1 cell: ttgtcctacttacaacactgtgcttagtaatggttattgcgactttatccttgttctgaa
i want to count how many "a" in this cell . which formula i can use to solve this problem ?
thanks
hi , i have this in my 1 cell: ttgtcctacttacaacactgtgcttagtaatggttattgcgactttatccttgttctgaa
i want to count how many "a" in this cell . which formula i can use to solve this problem ?
thanks
=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))
where your string is in A1
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Hi, in your case (a single character) this will work:
Formula:Please Login or Register to view this content.
However, most people would want to ssearch for more than one character, in which case this is needed:
Formula:Please Login or Register to view this content.
which counts the number of "tt" in the string.
Does this provide you withthe answer?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
It works !!!!! thank you so much
just to add another option for case sensitivity issue
e.g. AAAAaaaaAAAaaaa
=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"A",""))
or change to Lower() then "a"
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There you go, 3 answers for the price of 1!
Can you now mark the thread as closed, and say "thanks" to those who helped by clicking teh Add Reputation button at the bottom left of their posts.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
OMG, Tony. I was once a PhD Biochemist & I didn't notice the pattern. Time I was put out to stud. If only...
You could also use a cell reference for the letter that you want to get a count of. The letter to be counted is in M1:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks