Excel Unplugged

Case sensitive/insensitive Sort in Excel (bug or a feature)

This post will talk about the way that Excel sorts data and the Case Sensitive sorting it offers.

If we look at this data

Case sensitive/insensitive Sort in Excel

And sort it in ascending order (A-Z), we get

Case sensitive/insensitive Sort in Excel

It’s easy to see that there is no case sensitivity here, but there is a way to turn it on. You go to DATA/Sort

Case sensitive/insensitive Sort in Excel

In the sorting form you get, there is an Options window that allows you to say whether your sort should be Case Sensitive or Case Insensitive.

Case sensitive/insensitive Sort in Excel

Now if we choose case sensitive sorting, we get the sort order on the left whereas you might be like me and say that we should get the sorting as it’s seen on the right…

Case sensitive/insensitive Sort in Excel    

Obviously the length of the string also has effect on sorting. This is called a feature, but in my opinion it just makes Excel sort wrong!                         

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

503 Service Unavailable

Service Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Additionally, a 503 Service Unavailable error was encountered while trying to use an ErrorDocument to handle the request.