One way:

In a blank column (say D), enter:

D2: =RIGHT(A2,2)

and copy down. Then sort on that column, which can be hidden if you
wish.

In article ,
"LC" wrote:

Hi,

Is there a way to sort a list by the last 2 letters of a
word in VBA?

Thank you,
LC