Insert a column with the formula =RIGHT(A1,3), fill down, and use that
column as your sort key

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"jb" (donotspam). wrote in message
...
I have a spreadsheet with a large amount of data, I want to sort on a
column
that has part codes in it. ie. 1xxx11111zzz, some codes have the following
code structure 1xxx11111zzz@aaa who do I sort on the @aaa part of the code