Hi all,

I would like to request your help.

I have build a vba code which provides me with a column full of data. The length of this column is a variable, different each time.

In this column, each cell contains either one or multiple names, divided by a comma

Thus, say starting Column "K4:K8" (but length is variable)

AA,BB,CC
AA,CC,
BB
AA,BB,DD
AA

Out of all this information, I would like to list the different names, and paste them somewhere else.

Thus:

AA
BB
CC
DD

I tried splitting the cells, but due to the varying nature, I was not able to make it work.

So my plan was: after splitting, I would have to remove the commas, put all data in a single column and remove duplicates and sort it alphabetically.

Any help would be much appreciated.