Sorting by the last numbers in a long number

[Guest]

Hello,

In my company we have a excel worksheet that has workorders and we want them to be sorted in order of the last number(s) in the workorder. Example:

Workorder
3647465
3737621
2947363
8545454
5656387
1677672
9736376
8948464
9545456

Sorted (they way we want)
3737621
1677672
2947363
8545454
8948464
3647465
9736376
9545456
5656387

Can some one tell me how to sort like this. I tried just clicking on sort but it sorted by the first number in the workorder not the last. Also I want to have it keep the data in the columns that are next to the column of workorders together. Example:

Workorder Tech
3647465 Bob
3737621 Joe
2947363 Jon
8545454 Bob
5656387 Bob
1677672 Jon
9736376 Joe
8948464 Jon
9545456 Jon

Sorted (they way we want)
Workorder Tech
3737621 Joe
1677672 Jon
2947363 Jon
8545454 Bob
8948464 Jon
3647465 Bob
9736376 Joe
9545456 Jon
5656387 Bob

 

[Ken]

One way:

In C1 enter =RIGHT(A1,1)
Copy the C1 formula down to all the rows that have data in
Column A.
Select columns A, B and C and select Data>Sort.
You can then hide column C, if you wish.

-----Original Message-----
Hello,

In my company we have a excel worksheet that has

workorders and we want them to be sorted in order of the
last number(s) in the workorder. Example:

Workorder
3647465
3737621
2947363
8545454
5656387
1677672
9736376
8948464
9545456

Sorted (they way we want)
3737621
1677672
2947363
8545454
8948464
3647465
9736376
9545456
5656387

Can some one tell me how to sort like this. I tried just

clicking on sort but it sorted by the first number in the
workorder not the last. Also I want to have it keep the
data in the columns that are next to the column of
workorders together. Example:

 

[Domenic]

Hi,

C2, copied down:

=RIGHT(A2,1)

Then, select Columns A, B, and C, and sort by Column C.

Hope this helps!

 

[Guest]

Thanks so much guys that worked

One way:

In C1 enter =RIGHT(A1,1)
Copy the C1 formula down to all the rows that have data in
Column A.
Select columns A, B and C and select Data>Sort.
You can then hide column C, if you wish.

workorders and we want them to be sorted in order of the
last number(s) in the workorder. Example:
clicking on sort but it sorted by the first number in the
workorder not the last. Also I want to have it keep the
data in the columns that are next to the column of
workorders together. Example: