| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I sort SSNs in Terminal Digit Order using Excel?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do I sort a column by the LAST digit of the data? | Excel Discussion (Misc queries) | |||
| How can I sort multiple months/years WITHOUT Alpha order taking o. | Excel Worksheet Functions | |||
| I have two identical pivot tables with different sort order of th. | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
Threaded Mode
