software

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.

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

quot;Dave Oquot; wrote:

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

See: www.worldstart.com/tips/tips.php/2036quot;pfullerquot; gt; wrote in message
...
gt; Doesn't always work. Code only works on the first character of a string,
gt; which will usually be the only one capitalized, but not always. I'm trying
to
gt; do a case sensitive sort of a list of filenames/paths, so there could be
gt; capitals anywhere in the string.
gt;
gt; quot;Dave Oquot; wrote:
gt;
gt; gt; As a workaround, you might insert a column next to the column that
gt; gt; contains Cat dog apple Aardvark, and enter the formula
gt; gt; =CODE(A1) where A1 is the word in question. CODE returns the ascii
gt; gt; number of the first character; you can then sort on this for ascii case
gt; gt; sensitivity.
gt; gt;
gt; gt;