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.

"aphriam" wrote:

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