I'm stuck with this issue. A cell has items separated by ; with multiple items and need it to sort in alpha. The number of items may vary (can have 1 to 30+) within one cell.

Ex: Text in one column:

Ba,Ca,Aa
Ga,Da
Ta,Ha,Ea,Xa

Result:
Aa,Ba,Ca
Da,Ga
Ea,Ha,Ta,Xa

I can't find the right thread to deal with this... Hope this great board can help.