Get rid of duplicates in an comma array in one cell

[marieApplied]

Current contents of a cell:
10, 10, 100, 10, 100, 10, 100, 100

Would like to eliminate duplicates and get
10,100
Do this automatically without running a filter. Does anyone have any ideas?
Thanks, Marie

[Palmetto]

Doing this via a formula would be tough.

My suggestion is:

1. Text to columns using comma delimiter
2. Copy results of above
3. Paste Special > Transpose
4. Advance Filter for unique values using the option to copy to another location

[marieApplied]

Hi, Thanks but I was looking for something to be able to strip out the duplicates with a function. Don't want to do it manually.

[Palmetto]

Remove Duplicates From Single Cell