I want to extract line with the string "product" from this cell text. I don't know how to start this (rookie here).
Text -
-------Insights------- <> INSIGHTS <>-I am just an insight<><><> OPPORTUNITIES<>-I am a product insight<>I am not an insight <><>
I tried writting
=MID(D2,FIND("Product",D2,1),(LEN(D2)-LEN(?)))
Please help. Thanks in advance.