Can you Remove Terms from a String using a formula?

So I have an interesting situation that I would normally just do a simple find and replace to remove the words I don't want, but with a hundred terms, its tough to do.

I created a simple example to explain what I am trying to do, but I don't know the proper formula for column C.

What I am looking for is a simple formula that will reference the words in the green, and scrub them out of column A.

Any ideas?

Thanks in advance!
Aaron

Remove Terms Example.xlsx

Hi,

Check the updated file,

Punnam

Hey Everyone,
So this is awesome, thanks for the help. But in the example I attached, I added all the names I want removed in the front, but this might not be the case (it's only an example). So the formula which references right or left etc, won't work.

Is there another way? What I am effectively trying to do is replace the word with nothing. So it's basicall a find and replace, but off of an entire column of keywords.

Thoughts?

XOR LX actually seemes to have the right formula... awesome.

Let me check on those capital letters.

Might be helpful to bake in the trim...

Although, im not entirely sure I understand the formula in its entirety... Can you explain it?

Looks like I will need the capital letters turned into lowercase ones in column E. Any ideas there?

Hi ,
Have u checked my post 6 I have updated the file with a vlookup + & find Condition which will search for the specific names Listed in green Color

Punnam

to turn Capital letter to lower use = Lower()
Punnam

right, I did that, but I want to get it into the formula some how. It's less important.

@ afriedman ,
hi
kindly address to whom the Post 12 is referring, as u r getting answers from various forum members

Punnam

I am referring to XOR LX....
I am not sure your solution is going to help me.

afriedman

Thanks for Replying .

Punnam