... Maybe Microsoft had some reason for doing it that way ...
The soft order that Excel uses has to do with language. If a strict ASCII code ordinal was used, a lower case
a would come after the upper case Z and several special characters. When Excel sorts alphabetic strings, all of the following characters come before a
B,
A a ª Á á À à Â â Ä ä Ã ã Å å Æ æ
... which makes more sense when sorting alphabetic strings in a multilingual product. Someone has probably written this down in a standard, possibly even an ISO standard, but I'm not specifically aware of it.
Use CHAR() and CODE() together with ROW() and Paste Special, Values to create a list of characters that you can sort by for an example list you can refer to. You can find one I made a while back
here.
25 people found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
