Help for Medical Records sorting
I know this has been queried before but unfortunately, I cannot locate it. Our office deals with medical records numbers and we often have need to sort them numerically. An example of these numbers would be 09275361. The sort required for this would need to first,consider the last two numbers (61) then the 5th and 6th numbers (53) then the 3rd and 4th number (27) and finally the 1st and 2nd numbers (09). The first digit (0) requires that the field be formatted as text as it essential that it be shown in the final result. As speed is of the essence when this sorting needs to be done, I am looking for the easiest way to enter this into a spreadsheet (if possible) without using a helper column, which I would assume would require manual entry.
|