vba - remove duplicates in a text string

[monsierexcel]

i have a string that has produced duplicate words

AC2 >"test grey grey white black white" what i want to produce> "test grey white black"
AC3> "blue green green black white black" what i want to produce> "blue green black white"

is there a way in VBA to remove duplicate words out of a string and present in the info as a formula for each row?
i have seen a function available to handle this but not sure how i present these functions for each row?

thank you guys

 

[Fluff]

As this is a totally different question, please start a new thread. Thanks

 

[bioplz]

Is there any easy way to account for commas?

For example: 10.1, 10.2, 10.3, 10.4, 10.1, 10.2, 10.3
output with this code is: 10.1, 10.2, 10.3, 10.4, 10.3 because there is no comma after the second 10.3 it does not register as a duplicate.

I want the output to remove the last number and the commas. So, essentially, I want the code to remove the number and any following commas.

 

[Fluff]

Hi & welcome to MrExcel.
Please start a thread of your own for this question. Thanks