View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FlipperT FlipperT is offline
external usenet poster
 
Posts: 1
Default Counting the number of specified text characters within a cell

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.