I want to extract line with the string “product” from this cell text. I don’t know how to start this (rookie here).
——-Insights——- <> INSIGHTS <>-I am just an insight<><><> OPPORTUNITIES<>-I am a product insight<>I am not an insight <><>
I tried writting
=MID(D2,FIND("Cross Border Payments",D2,1),(LEN(D2)-LEN(?)))
Please help. Thanks in advance.
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.