Sort with text and numbers

[Guest]

I need to sort by item numbers which conatain both text and numbers. Here is
an example of what I need to sort
1
2
1X
2X
25
25X
26
112
113
112X

I need it to sort like this:
1
1X
2
2X
25
25X
26
112
112X
113
the best I have been able to do is:
1
1X
112
112X
113
2
2X etc.

 

[Guest]

If this is something you have to do frequently, Jim Cone has a fine
commercial Add-in called "SpecialSort" that will do it just fine. It's
available at...

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3

 

[David McRitchie]

Or for free you could find an example on
http://www.mvps.org/dmcritchie/excel/sorting.htm#extract
http://www.mvps.org/dmcritchie/excel/sorting.htm#pcdigits

And you would see what is happening.