Find & Count text within a cell

[Guest]

Hi All

I need code to count text within cells, example below:

A | B | C | D
1

2 tr,tr | tt,tr | rt,tr | tt,ty

3


i want to be able to count the amount of times "tr" is found within this
range of cells "A22". obviously the codes has to read within the cells.
"tr" is there four times.


Thanks
Ernie

 

[Bob Phillips]

=SUMPRODUCT(--(LEN(A22)-LEN(SUBSTITUTE(A22,"tr",""))))/2

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hey Bob,

It worked ... thank You

=SUMPRODUCT(--(LEN(A22)-LEN(SUBSTITUTE(A22,"tr",""))))/2

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)