How to sort a column in reverse (right-to-left)

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.

>-----Original 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.
>.

You could highlight the cells and use Data>Sort and then
select which columns you wish to sort by. HTH
>

I don't believe you can sort both in one operation. Select your cells, then
Data|Sort and select options. You can then choose "Sort left to right"
instead of "Sort top to bottom". Select ascending or descending depending on
the order you want. Then Sort it again going top to bottom (normal).

"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.

With your data in A1:D5, select the entire range. Click on Data|Sort, select
sort by Col D. In the next sort option, select sort by Col C, and click on
OK, that's it

"[email protected]" wrote:

>
> >-----Original 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.
> >.
>
> You could highlight the cells and use Data>Sort and then
> select which columns you wish to sort by. HTH
> >
>

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.

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" <[email protected]> wrote in message
news:[email protected]...
: 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.