Excel 2003 can't do case sensitive sorting!

T

TelcordiaJack

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.
 
D

Dave O

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.
 
P

pfuller

Doesn't always work. Code only works on the first character of a string,
which will usually be the only one capitalized, but not always. I'm trying to
do a case sensitive sort of a list of filenames/paths, so there could be
capitals anywhere in the string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 case sensitive problems with New Database Query 1
upper case - lower case issues - dropdown box is case sensitive??? 0
Case-sensitive sort problem 1
case sensitive IF, Visual Basic macro IF 2
Excel 2003 case sensitive problems with New Database Query 1
Sort by Large, Offset from Match, Duplicate values problem 2
Consolidation: Combining groups of identical items 2
Problem sorting by date after 2029 on Excel 2003 1

Top