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 that 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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Arsenal" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>