Excel 2003 can't do case sensitive sorting!

Giganews Newsgroups
Subject: Excel 2003 can't do case sensitive sorting!
Posted by:  TelcordiaJack
Date: Wed, 3 May 2006

Contrary to the documentation, sorting an alpha column containing:  Cat, dog,
apple,
and Aardvark (with the case sensitive option selected) results in: Aardvark,
apple, Cat, dog.  With a case sensitive (ASCII colating sequence) sort, the
results should be:  Aardvark, Cat, apple, dog.  FWIW, I notice that this
problem has been reported in newsgroups in the past.

Replies