Hi,

I have a large list of data in a .txt file (LIST 1) that contains over 100,000 entries of website urls surrounded by a database reference number and special shortcodes like: (I removed actual url format due to not being able to post)

18967[abs]URL1[abs]wp[abs]0[abs]active
18968[abs]URL2[abs]wp[abs]0[abs]active
18969[abs]URL3[abs]wp[abs]0[abs]active

I will have to split it up into at least 2 worksheets due to the large number of entries.

I have a small list of urls (LIST 2) without the special code or database numbers in a column of another worksheet such as:

URL1
URL3

I want to delete all rows from my LIST 1 that contain urls from LIST 2.

Thanks!