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 that
option.

Thanks.


--
Arsenal
------------------------------------------------------------------------
Arsenal's Profile: http://www.excelforum.com/member.php...o&userid=27417
View this thread: http://www.excelforum.com/showthread...hreadid=469325