Forum Discussion
jonahw218
Feb 29, 2020Copper Contributor
Custom Sort Alphabet Alphabetizing
So I want to alphabetize a list with a custom list of symbols. I've tried the custom list function but this only sorts cells if the exact word/symbols are in that custom list. For example, if I h...
Ghazanfar Abidi
Feb 29, 2020Brass Contributor
jonahw218 I was thinking something similar to what Riny_van_Eekelen laid out in his answer. But instead of encoding characters to numbers, I'm going to alphanumeric so that you can handle more than 10 characters. Sample attached.
Riny_van_Eekelen
Feb 29, 2020Platinum Contributor
Ghazanfar Abidi Well done. And a much neater solution. Don't know what I was thinking.