Try this amendment to the formula to get the last 7 characters:

=RIGHT(TRIM(G2),7)

Copy down, highlight all the columns you want sorted and sort on column
H.

Hope this helps.

Pete