Example: My name is Bob Smith Bob Smith.

I want to have the output: My name is.

This is just an example. Thanks

I tried another macro in vba editor but it did not delete all copies of a duplicate word. Wanted words or strings that appeared twice or more to be completely deleted.