Hi all,

Let me explain you the problem I am facing. I have a list of words, let's say for example: "butter", "honey". I would like Excel to extract, from a cell, all the words from the list that are used in this cell. Let's have an example:

I love butter but not honey butter honey
I don't like butter butter
I like cherries
I always eat honey, it's the best food ever. honey


Have you got a solution with a formula or a macro ?

Best regards,

Larry.