How can I find how many times the word bread is in a whole range of cells,
say from A1:A10?

"Dave Peterson" wrote:

Just a small warning.

If you want to count Bread, BRead, BREad, ..., bread as all the same string, you
could use:

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

=substitute() is case sensitive.

And the first suggested formulas will only look for lower case "bread".



art wrote:

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?


--

Dave Peterson