hello everybody I am new to excel and I am trying to figure out how to count continuous letters in different cells in a row. the version of excel I have is 2003.

the case will be like this:

each row goes from b1 to cm1.each cell in that row contains 1 letter a, b or c.

the letter b will have no influence in the result, it will not count.

the letters that I would like to count are a and c. the results of a will be displayed in cell cn and the results of c in co.

the result I am looking for is how many counts of 4 plus consecutive a and c are.

ex:

aabbbaaa cccbcc aaaacaca bbbbcbcccca in this case a= 2 four+ counts c=2 four+ cunts b don't matters.

I have 50 rows in the document.

thanks to all in advance. your help will be really appreciated.