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

As a workaround, you might insert a column next to the column that
contains Cat dog apple Aardvark, and enter the formula
=CODE(A1) where A1 is the word in question. CODE returns the ascii
number of the first character; you can then sort on this for ascii case
sensitivity.