Can i a list of numbers by the last two digits? 1

[Starrizzo]

I have a list of account numbers that i need to sort by last two digits of every number. The list is about 5000 long so going through and adding a delimiter is out of the question. Is there any way I can do this???

Example of list:

0025634657
0012265466
0032654465
0065487654

 

[fredericofonseca]

if dealing with Excel you can create a formula on another column like this
=right(A1,2) (assuming data is on column A)
and then copy it down until the last line of data.

Then sort by this field.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com