I have a spreadsheet with a column of box numbers:

A21
A1407
A828
B7371
B986
H2490
E1082
E232
H267

When I sort the column I get:

A1407
A21
A828
B7371
B986
E1082
E232
H2490
H267

What I want is:

A21
A828
A1407
B986
B7371
E232
E1082
H267
H2490

No matter how I format the cells before I sort, I cannot get it to look like
what I want. Apparently it has something to do with the default alpha
numeric sort in excel?! Is there any way around it? Am I making sense?