View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jshendel Jshendel is offline
external usenet poster
 
Posts: 24
Default Count consecutive characters within a cell

I have a genetic sequence such as:
AATTCAGTTACTTTTGCA

I need a formula that will tell me if this cell has a run of 4 or more
consecutive letters. The run can consist of 4 or more A, T, C, or G.

The above example can return simply as "yes" or can be as complex as "this
cell has 4 consecutive T's"

Thanks,
Josh