How to remove certain rows from Excel?

Question

excel

There is a specific list of strings. Example
Arms of the Bogatyr Loading Screen
Ascendant Lone Druid Loading Screen
Ascendant Nyx Loading Screen
Consuming Tides Loading Screen
Cry of the Battlehawk Loading Screen
The following lines should be removed from this list. Example
Ascendant Lone Druid Loading Screen
Consuming Tides Loading Screen
Through "Replace" one at a time it takes a long time
Is it possible to set a loop in which, through a separator character, specify a list of lines to be deleted. Example:
Ascendant Lone Druid Loading Screen ; Consuming Tides Loading Screen

Answer 1

Can.
Insert a new list "to be deleted" on a new temporary sheet, use the formula = VLOOKUP on the original sheet to find matches, set a filter (criterion - does not contain # n / a), delete.