View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TelcordiaJack
 
Posts: n/a
Default Excel 2003 can't do case sensitive sorting!

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.