Sorting by only numbers

[George]

How to sort ignoring letters, Excel 2003
ny only containing numbers,
For example
default sorting wanted sorting
AA101 AC02
AB99 AB99
AC02 AA101
Thanks
George

 

[Dave Peterson]

You'll have to separate the numbers into a different column.

If all the letters are exactly two digits, you could use:
=--mid(a1,3,255)

(the -- converts the text that =mid() produces to a real number.)

Then you can sort your data by using this helper column.

 

[George]

Thank you for your response,

Unfortunately the letters ranging from 2 to 8 Approx, Is there a macro for
it?

 

[George]

Thank you for your response,

Unfortunately the letters ranging from 2 to 8 Approx, Is there a macro for
it?

 

[Dave Peterson]

You could use a formula like:
=--RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1)
to get the rightmost group of digits.