Remove the words from Cell A1 that are in Column B

Hi Grens,

Welcome to the Forum! Is a VBA solution acceptable? If so:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Can't have array references for a search. If your list in column B is only 3 records long, you could try:

Please Login or Register  to view this content.

This method gets more tedious the more entries there are. Otherwise, you may want to go the User Defined Function method.

Here's an example of a UDF that mcmahobt and xladept were referring to.
It's installed and working in the attached file in cell B1.

Please Login or Register  to view this content.

Originally Posted by Grens

Works great exacly what i was looking for. Now i will try to undarstand how this function exacly works. Thanks a lot

Thanks for the rep. points.

The function is pretty simple, it puts all the words you want to filter out into an array and then loops the array and uses replace to replace them one at a time with an empty string. If there is only one word it goes to the else part of the code.