Thanks to Dave Peterson and Je McGimpsey, it works great, thanks a lot. I saw
basically the same answer from Dave Peterson in old question you aswered a
while ago. Thanks.


"JE McGimpsey" wrote:

One way:

=(LEN(A1)-LEN(SUBSTITUTE(A1,"bread","")))/LEN("bread")

In article ,
art wrote:

Which formula do I have to use to see how many times a certain text is in a
cell. For Example, in cell A1 is the text "bread milk bread", how can I in a
different cell see how many times the word bread is in cell A1?