how to fins sub strings with SUMPRODUCT?

Originally Posted by HolmesM

I've tried all three - JohnTopley's works! Tony and Pete's close, just a matter of embedding.

Hmmm...

I get the same results from all 3 formulas.