ContributionsMost RecentMost LikesSolutionsRe: Sorting TextList in formulaThe source is a combination of 2 text fields in the same record, I SearchAndReplace([Name]& " " &[Description]," ",";") and then need to sort the words alphabetically. ------------------------------ Saar Litman ------------------------------ Sorting TextList in formulaAny option to sort a Text list with words in alphabetical order? I need to sort something like this: BB;CC;AA;DD;EE;GG;FF to AA;BB;CC;DD;EE;FF;GG in a formula. I'm currently looking at using Part to break the list into individual elements then use Min to look for the elements and extract the first word, but then I need to recreate the list minus the word I already found, this need to happen for every word (max 20) I'm already in like 40 with no end in sight Am I on the right track? Any help will be appreciated. ------------------------------ Saar Litman ------------------------------