I was reading the recent OW issues relating to sorting in Word. That reminded me I used to be curious about how Excel orders characters. I mean, if you write in A1
then write in A2
and finally write in A3
the result of the formula will be: TRUE. That means that Excel has an internal list of characters and in that list, "*" comes before "/". I haven't tested it yet, but it would be reasonable to think Word makes use of an identical list.
My question, just out of curiosity by now, but it may be useful for an eventual macro in the future, is: is there any documentation revealing the complete list for text characters? Keywords for Googling this one are not very easy. I got all sort of results but the ones I wanted.
Thank you in advance