View Single Post
  #1   Report Post  
Lady Layla
 
Posts: n/a
Default

Can you split the column into 4 seperate columns using data ---text to columns
(format all cells as text beforehand so you dont lose leading 0's)?
Then Select entire region and sort by Col D then other criteria

"retman" wrote in message
...
: 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.