Quote Originally Posted by stevekirk
hi,

sorry i have confused you

the text in the cell could be "egbd/saw/egbd/dis" or "egbd/saw/dis/saw"

i want to know how many times "egbd" is in that cell or then in the next cell
how many times saw in in it

sorry for the confussion

steve
try this

=(LEN(A1)-LEN(SUBSTITUTE(A1,"egbd","")))/4

you need to manually enter a digit at the end of formula (4 above formula)
this infact is length of text you want to count in a cell.
here is "egbd" has four characters so you need to enter it at the end of formula.

Regards.