Find & delete duplicate words in a cell from a separat list of words that can be added to

Long time lurker, first time poster!

As the title says, I need a macro which searches a single column for duplicate entries.

Some of the duplicates I want to keep, so I need to remove the unwanted duplicates by using a reference list of words to dedupe.

Any ideas? Here is an example of my data:

Capture5.JPG

I'd like to dedupe 'Handbag' and leave 'Ladies''.



Thanks in advance!

Originally Posted by dilipandey

Hi Peter,

Welcome to the forum.

<click on below 'star' if this helps>

Thanks Dili!

I actually need something more complicated than this... I need a single 'handbag' remaining, not remove all of them.

I just need an array that I can populate with words I want to deduplicate inside each cell, and run a macro on it.

I already use the 'substitute' function to correct many common spelling errors on my files.