Hi Guys
Am here and is my first post any help welcome.

am trying sort cell string which as separated "," and in to A-z format

example
cell A1 has text "Red car,Orange bag,Black Ring" and to result of the text displaying like "Black Ring,Orange bag,Red car" in cell B1

the text string can be various lengths but each split must be made after the "," then sorted by A-Z format.

not sure how I would do this any help in the right direction welcome.

thanks