Excel is not sorting letter correctly

microsoft-excel sorting

I have a weird problem with Excel: it is sorting the letter "CH" incorrectly (it places "CH" after "CZ"). As you can see in the attached image, it only happens with "CH" and not with any other combination like "AH", "DH". Anyone has an idea what is going on?

sort


Solution 1:

Based on the querent’s response to a suggestion in the comments, it appears that Excel uses the system language setting for sorting. As such, if the language is one that considers the CH digraph a separate letter from C, this issue may occur in sorting. See Wikipedia on the CH digraph for more information; Spanish is one of several languages that might cause this issue.

Related

Can we use a server's own private key from .ssh folder to SSH into it?
Why does deleting a gateway route and then re-adding it make routing suddenly work?
Insert big text into multiply rows by keyword into Excel or google spreadsheets
How to resolve Internal Errors in the .NET Runtime
SOCAT on WINDOWS: why do I need pipes option for EXEC address?
Hierarchical ssh connection with Putty, or maybe some other software?
Import 11GB PST file to Gmail without Outlook
Bash on macOS, alt+d inserts ∂ instead of removing word
Slow computer because of bad SSD?
X11 forwarding: Unable to init server: Could not connect: Connection refused. What is needed for an X11 connection?
A non-RAID Intel hard drive is not displayed as a Win10 installation option in HP Notebook laptop
Replacing '-' with '/' in Notepad++