Hello,
In a SINGLE cell (B2 for example) I have a formula (not text) that gives meI am looking for a way to return to another SINGLE cellPeter, Paul, George, Paul, PeterIn other words, eliminate doublesPeter, Paul, George
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
Bookmarks