Find a set of string and then remove it if found.

I have pasted the image for the query in which i want that,

If the data in the column “A” contains the any of strings available in the column “B”, then the matching string (maximum part of it) should be removed and the resultant part should be left in column “D”.

Excel Query Image


List of input URLs in text :

List of strings to be removed:

Result Needed for each URL:




By: Prasun

Leave a Reply

Your email address will not be published. Required fields are marked *