Sorting with a Custom List Bug

New Contributor

I need to sort grades in order, e.g., A, A-, B+, B, B-, C+, C, C-, etc.


Normal sort places has the order B, B-, B+, and using the custom list with the grades in perfect order results in, A-, B+, B-, C+,C-, A, B, C, D, F.  It somehow places all +/- grades first and then the others.


Is there any workaround?  I would expect a custom list to dictate the order of sorting.


I'm using Excel for Mac 2011.




4 Replies

@Chazzs , on Windows it sorts correctly if add custom list from from File->Options->Advanced (imported from column E here)


Perhaps something similar for Mac, not sure

@Sergei Baklan 

Thanks Sergei.  I did a little more investigating.  When I TYPE in random grades and sort with a custom list it's correct, but when I copy and past a list of grades off of a website the sorting is incorrect.  Something is being copied from the webpage that is confusing the sorting.  I'll see if I can save it as a text file and then try a new sort.  Interesting.




When a table is copied from a webpage it needs to be Paste Special as Unicode Text.  This strips whatever malicious formatting is hiding in each cell, and  now can be sorted correctly with a custom list. Whew.



@Chazzs , yes, when you just copy/paste from web, quite often you copy with your data invisible characters from HTML code which you shall to remove after that.


Anyway, so far so good.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies