Hi, I’m a moderator for this topic. It seems the professional has left this conversation. This happens occasionally, and it's usually because the professional thinks that someone else might be a better match for your question. I've been working hard to find a new professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.
I wonder whether you're OK with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you. Thank you!
Ok here is a sample file with the formula in the yellow cell
Type in cell D1 the word or part of the text that you want to look for, and the formula in C1 will display the entire text where that word was found
Hope this helps. Thank you for rating this answer "Excellent" or "Good" if I was able to answer your question