ENUMLIST with "Auto-Complete Other Values" set, listed in Alpabetical Order

I have an ENUMLIST with “Auto-Complete Other Values” set. It works fine except that the list is give is not in alphabetical order. I’ve tried usind SORT() but it doesn’t display it correctly because some of cells it selects are themselves a list because its an ENUMLIST. So I see

A,
B,
A,B,C
B,D

Anyone know how to sort it alphabetically and only show indiviual items?

0 6 1,464
6 REPLIES 6
Top Labels in this Space