How can I sort by numbers and not text?
 

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

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" wrote in
message ...

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