Remove duplicate words in a single cell

[AnitaSTA]

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

[Glenn Kennedy]

Have you tried the solution offered here:

http://www.excelforum.com/excel-gene...om-a-cell.html

[AnitaSTA]

Hi Glenn

Thanks for your response. I did look at that solution, but being a basic Excel user, it did confuse me a little. In the end, I moved Column to text with space as the delimiter, deleted the third column with the additional surname and used CONCATENATE to merge the data back to the one cell. Probably a vry basic way of doing it, but it achieved the desired result. Thanks for your response

Kind regards
Anita