Insert a new column next to your data, enter the formula
=RIGHT(A1,7), copy down as far as you need to go, and sort on
that column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sdmccabe" wrote in message
...
I would like to sort a column of alpha-numeric characters by
only the last
seven characters - can someone help? Thanks.