Column1
0021D8B9B5FE
0021D8B9B494
001FCAE8A6B1
0021D8B9B6BF
001FCAE88DEE
0021D8B9AD96
001FCAE8A9C8
0021D8B9B5F7
0021D8B9B90E
0021D8B9B758


I want to sort on the last digit on each value:

for example:
0021D8B9B5FE
If last digit start with 1,3,5,7,9,a,c,e (consider this odd numbers)
if last digit start with 2,4,6,8,0, b,d (sondifer this even)


So how can I sort each raw based on the last character being odd or
even in excel.

=thanks in advance