I have an Excel spreadsheet which has a field which contains both the name of the product and additional information about the product eg Zebra LP2824P 2" DT desktop printer, parallel with Dispenser (UK/EU)

I want to find out how many times in the spreadsheet the word "Zebra" appears. I have tried using the VB code:

=SUMPRODUCT(--(MONTH($B$2:$B$250)=7),--($D$2:$D$250="Zebra")) However this only finds the lines that only contains the word "Zebra" where there is nothing else in the cell.

Is there a way of selecting the word from the whole string?

Grateful for any help you can offer.