sort by the last 2 digits

G

georgeawwad

I have a long column of 5 digit numbers, i need to sort the column b
the last two digits, can it be done :confused: :confused
 
F

Frank Kabel

Hi
use a helper column with the formula
=RIGHT(A1,2)
copied down for all rows and sort with this column
 
Top