I'm having problem removing duplicate surnames in a single cell.
Example:

Joan Major and Jack Major

What I have found so far comes back as:

Joan Major and Jack

When what I need is:

Joan and Jack Major

I can't get it to delete the first instance - is that even possible????
Thanks. I'm going nuts and feeling lame.