Remove Duplicate Words from a Cell

I need to remove duplicate words within a cell. I know how to remove duplicate cells, but I can't figure out how to remove duplicate words inside a cell.

Example: Excel Forum is is so awesome! ---> Excel Forum is so awesome!

Thanks

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Here is my way...
uses some helper columns
have a look..!



Edit :- I personally feel SKTNEER solution is perfect for this one.. Short and quick...

If you are open to a VBA solution to achieve this, please follow these steps......

Open your workbook --> Press Alt + F11 to open VBA Editor --> On VBA editor's window --> Insert --> Module --> Paste the code given below (a user defined function) in the opened code window --> Close VBA Editor --> Save your workbook as Excel Macro-Enabled Workbook.
The code is as follows......

Please Login or Register  to view this content.

Now on your sheet, use this UDF like this......

	A	B	C
1	Original Data	Desired output
2	Excel forum is is so awesome!	Excel forum is so awesome!	=RemoveDupWords(A2)
3	Please help please me with this formula	Please help me with this formula

The formula used in B2 is as follows...
In B2

Please Login or Register  to view this content.

and copy down.

@sktneer

Nice one! Even if the duplicate word isn't the first one, this works perfectly.

Thanks Ron for the appreciation and liking the solution.

Hello Sktneer,

This function looks like exactly what I need but for some reason I keep getting #NAME? when I try to execute it. I know I even took your example verbatim.
Attachment 810300

Here is the function that I copied

Please Login or Register  to view this content.

Thank you very much for any help at all, it is greatly appreciated

john-i welcome to the forum.

This thread is over 8 years old. It is doubtful that the original contributors are any longer following it.

Also please review our rules. There aren't many of them and they are reasonably straight forward.

Rule 04: Hijacking (Please start your own thread. If you feel a particular thread is relevant to your question refer to it in your thread.)
and
Rule 02: Missing Code Tags (Since you are new I will insert the code tags for you this time.)

Thank you ahead of time and welcome to the forum again.