Hi,
I need to extract a sentence from the text in column A which contains one of the words (i.e. "pictures","memory","video","features"). I created a formula which extracts all text which contains one of the prescribed words but need to extract only a sentence with either of these words.
=IF(OR(ISNUMBER(SEARCH({"pictures","memory","video","features","capacity","price","quality"},A2))),A2," ")
Can someone help me please to create a new formula for this action?
I attached a workbook with the sample data.
Thanks so much!
Bookmarks