I feel like this is far beneath me, but here goes. I'm no wizard, but this is really frustrating me.

I have a column of alpha-numeric numbers - like so:

E109
E11
E11
E110
E119
E12
E12
E120
E120
E121
E121
M137
M138
M139
M139
M14
M140

I am trying to sort them like this:

E11
E11
E12
E12
E109
E110
E119
E120
E120
E121
E121
M14
M137
M138
M138
M139
M139
M140
M141
M142

I know it sorts right to left when a numeric value, and I don't know how to do it the other way.

I have tried formatting the numbers as a custom format "000" I have tried changing the format to numbers, text, etc..... I have also tried text to columns, then making the numbers 3 digits, then pasting the values, and combining them. I've finally tried =TEXT(a1,"xxxx")

Can anyone please help me with this situation? I am sure it's something super easy, or there is a way to split the column and format, etc.

Thank you,

Christianpax_mfst_all.xlsx