I have a worksheet column that contains cells with a list of words
in it, such as:
Example_1-02
Example_11
Example_10
Example_1
Example_12
Example_100
When you sort this using the default A-to-Z Excel sort, it orders
them in the following way:
Example_1
Example_10
Example_100
Example_1-02
Example_11
Example_12
However, this isn't the order in which I want them. I can get them
in the 'corrct' order by using a Quicksort routine that gives the
following order:
Example_1
Example_1-02
Example_10
Example_100
Example_11
Example_12
Now, the complicated bit... this works fine when I'm sorting a
single column, but how would I do about dealing with things if there
were multiple columns, and I wanted the other data to remain
associated with values being sorted? Any pointers?