How do I sort the last 3 digits first and then the first 4 digit?.

G

Guest

I was always trying to sort the list of Medical Records to be retrieved from
filing shelves which is arranged by Termianl Digit Filing system. In our
hospital, each patient has a 7 digit unit number and this unit number is
devided into two sections of primary number and secondary number.

for example. the files are arranged as follows:
2345-678
2346-678
2347-678
----_---
----_---
1234-679
1235-679

I would greatly appreciate if someone could help me to sort numbers in this
order.
Thanks
 
G

Guest

This is one way.

Copy the column of data to a blank column.
Data -> Text to columns
Set the delimiter to be -
Sort the columns as needed.
 
G

Guest

Create a helper column in (column B)
In B1: =--RIGHT(A1,3)
copy down as far as needed

Select data ranges
Data >> Sort >> sort by select Column B Ascending >> Then by Column A
Ascending >> OK

When you done delete a helper column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort by the first digit of a number? 7
How do I sort several 4 digit numbers by the last 2 digits in exc. 4
How can I sort a list of numbers by the last 4 digits? 2
How do I sort numbers based on last two digits? 3

Top