Sort with text and numbers
 

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.

Sort with text and numbers
 

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



"AM Stern" wrote:

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.

Sort with text and numbers
 

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

And you would see what is happening.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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



"AM Stern" wrote:

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.