How to remove (specific) Stop Words from a Text? I'm absolutely not getting it (:

[dooyou]

Hi Guys,

it costs me hours until now, but i'm not getting it. I'm not an experienced Excel user for this part and i hope you can help me.

From my point of view, the task is easy.

I have a Column (A) with a text. And I have a Column (C) with Stopwords in it.

What should happen now?

Excel should compare the two Columns and delete the Stop words found in Column (C) from Column (A). And always when I add some words to the
stop word list (C) it should compare it with (A) again and delete it.

I uploaded an Example file here.

Maybe it's easier if the Stop Word list is on a separate sheet? I created one, if you need it. The Stop words are there the same like in the "text" sheet.

Thank you so much!!

[MickG]

Try running this code from sheet "Text"

Please Login or Register  to view this content.

Regards Mick

[dooyou]

OMG, it seems to be working. I don't think that I should have problems with it in the future? Was it an easy task or only just for beginners?

[MickG]

You're welcome