I have numbers with a letter in front. I want to sort them by the number and ignore the letter. The only way Excel does it is by the letter (unless I'm missing something). Here is an example of my list:
A541
A586
A600
A618
A660
B299
B327
B416
B421
B501
B547
B567
L917
M125
N207
P196
PI93
T279
T284
T312
V180
V324
X327
X341
Z315
Z318
Z340
Z372
As you can see, it sorts it by the letter first, then number. I want it to sort by the number first, then the letter. Does anyone know how I can do this? Thanks!
Bookmarks