"Lee" wrote:

If the cell contains - r1, r2, r3 count=3 i.e r 3 times
if the cell contains d11,d12,d78.d56- I want to count number of times d
appears a cell.

Thanks for the quick response. It works wonderfully. Much appreciate it
Lee