How can I sort by numbers and not text?

[Arsenal]

I'm trying to sort my list (column B) but it sorts it like this:

A1
A10
A2

how do I sort it like this:

A1
A2
A10

without padding the numbers (A01, A02, etc)?

MS Word has sort by numbers but Excel doesn't seem to have tha
option.

Thanks

 

[Max]

Assuming data in col B, from row1 down
(data as posted is assumed representative in structure)

Use a helper column, say col C
Put in C1: =MID(B1,2,99)+0
Copy down

Then just select both cols B and C, and sort by col C, ascending