Sorting the contents of a text string in Excel in Alphabetical order.
Posted on 2016-10-04
I have the need to sort a text string in alphabetical order. (I would prefer a formula based solution if possible.)
Contents in cell A1: A123,B456,C789
Desired Output: ,,123456789ABC
As far as the order of the output, I don't really care. Could be Numbers, Letters, Special Characters or any mix therein...
Can this be done?