Hi there

Is anyone able to assist me in a formula to remove duplicate words from a single cell in a column? I have exported from MYOB to Excel and it has taken up the surname twice in a number of cells eg: Anita Morgan Morgan. Is there a formula that will delete the second Morgan?

Kind regards
AnitaSTA