The order of numbers mixed with letters

[sgg]

I would really appreciate some help with this!!!!!!!!!

Is there a way to program or trick excel into viewing a letter as being
bigger than another letter when combined with a number?

For example, I want to start with the lowest value of 1c followed by 1b, 1a
and then going up to 2c, 2b and 2a.


It's hard to explain. The problem is that I have to use numbers in an
ascending order whilst the letters go in a descending order. Oh, and the
number and letter need to be in the same cell!

If you know if this is possible I will be eternally grateful!!!!!!!!!

 

[Sheeloo]

One way to 'trick' Excel to have two extra (hidden if required) cols where
you can separate the nubmers and characters and sort on those cols.