In one regular text file I have a list of about 1,000 different keywords (Very straight forward. They are all single words with no spaces and there's a hard return after each keyword).

---

keywordslist.txt

Peter

James

John

Mary

Chris

---

Then I have an Excel file with a list of 100,000 different phrases in Column A (one phrase per row).

I want to delete all the rows that do not contain at least 1 keyword from my first list.

---

phrases.xlsx (These are mostly long phrases, some longer than 254 characters, one phrase per row)

Row 1 "Him and **Mary** are here" (keep this row because there's one or more of my keywords)

Row 2 "The boy called **Peter** and **Chris**" (keep this row because there's one or more of my keywords)

Row 3 "Michael and Ronald are there" (Attention: None of the keywords are present, so delete this entire row)

---

Can this be done in Excel alone? Or do I need a macro?
If it's not so simple as it seems, please guide me in the right direction. I do not have knowledge of VBA or macros but I'll give it my best try if there's no easy way in Excel :)
Thanks,
Alex