An example would be the following:

Say I have five SSNs that I need to put in TDO. These SSNs a
123-45-6789
987-65-4321
567-89-1234
246-81-3579
192-83-7465

They would be in TDO like this:
987-65-4321
567-89-1234
192-83-7465
246-81-3579
123-45-6789

So in my original post I miswrote that it is the last four, followed by the
next two, followed by the first three. It's actually the last two,
second-to-last two, third-to-last two, then first three.



"Ken Wright" wrote:

Give us some examples of your data, and how you want it all to sort.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"postitnote" wrote in message
...
I work in a medical records office and we are attempting to combine five
years' worth of records onto one spreadsheet. Our office uses Terminal
Digit
Order (or TDO) and it doesn't appear that Excel can sort this way as it is
in
order with the last four digits, then the middle two, then the top three.
Does anyone know if there is a way to do this without having to put the
SSN
in three separate columns and then merging the columns together somehow?