Sorting cells with strings and numeric values

Hello, I have a cell(s) that starts with random letters and then the actual part number. For example:


LBDSAL8545
RUYUAL8553
LBDRTY8552
LQERAL8548
LBDUAL8547


Is there a formula that will allow me to sort ONLY by the numeric values rather than the first 6 letters? Thank you.

You can extract the numeric values to a helper column ( using Text to columns or the RIGHT function) and sort the resulting table by the values in the helper column ( which can be hidden)

Is every value in your list made up of six letters and four numerics at the end, and if not, what are the possible variations ?