I'm sorry, but I forgot to mention that these 'numbers' are all in one cell,
so "DC 00 03 20" is in one cell. And another thing is, that I want to have it
sorted that you first see all the 'numbers' which end on 0, after that, 1
etc. Like this:
DC03210
FE65520
BD92940
CT84170
GT99280
SE38734
FT01484
DR04567
RD31798

I hope you know how to tackle this one!

Thnx!



"retman" wrote:

Hello,
Below you can find an example of my worksheet:
DC 00 03 20
FE 06 55 20
BD 09 29 40
CT 08 41 70
GT 09 92 80
In this example, you see the sort as I want it (right-to-left and
top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting
all the numbers by hand.