Hello,
In a SINGLE cell (B2 for example) I have a formula (not text) that gives me
Peter, Paul, George, Paul, Peter
I am looking for a way to return to another SINGLE cell
Peter, Paul, George
In other words, eliminate doubles

Please note that I may have to do it several times for multiple cells so a formula (if possible) would be preferable. If a formula is not possible a macro would do
Also the number of names in B2 may vary from time to time

If it is any help, one idea I have is to copy B2 / paste special values to another cell, use Text To Columns, then copy/paste special transpose, use Remove duplicates and then concatenate them. However, i still have to do it many times and more importantly I am looking for sth more elegant so that I do not need to have an idle range

Thank you