Thread: Sorting by the last two digits with a twist

Hello Everyone,

Through this forum I learned how to sort our case numbers by the last two digits:
=value(right(A1,2)) However, some of our cases look like this 1110056425-01. The "-01" means nothing for my sorting purpose. I need to sort by the last two digits prior to the "-01" in this example I'd need to sort by the "25". I couldn't figure it out. Help please.

try:

=RIGHT(LEFT(A1,FIND("-",A1&"-")-1),2)+0

this should work for both items with the -01 and items with no dashes

the +0 eliminates need for VALUE() function.