Automatically Find and Replace a column of text with new random text

[gmooney]

I have a column of about 4,000 rows of text that has many duplicated values (as it should). I simply want to be able to change the name of the text that is being displayed for masking perposes as the data is sensitive data. I thought i did this once before with an Excel Add in.

So every time I see something like

Coca Cola

in the 4,000 rows I want it to be masked to where you don't recognize it. There are probably about 1,000 unique entries in the 4,000 rows thus a normal find and replace would be inpossible.

Any thoughts