software

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.

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

www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3
quot;AM Sternquot; wrote:

gt; I need to sort by item numbers which conatain both text and numbers. Here is
gt; an example of what I need to sort
gt; 1
gt; 2
gt; 1X
gt; 2X
gt; 25
gt; 25X
gt; 26
gt; 112
gt; 113
gt; 112X
gt;
gt; I need it to sort like this:
gt; 1
gt; 1X
gt; 2
gt; 2X
gt; 25
gt; 25X
gt; 26
gt; 112
gt; 112X
gt; 113
gt; the best I have been able to do is:
gt; 1
gt; 1X
gt; 112
gt; 112X
gt; 113
gt; 2
gt; 2X etc.

Or for free you could find an example on
www.mvps.org/dmcritchie/excel...ng.htm#extract
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;CLRquot; gt; wrote in message ...
gt; If this is something you have to do frequently, Jim Cone has a fine
gt; commercial Add-in called quot;SpecialSortquot; that will do it just fine. It's
gt; available at...
gt;
gt; www.realezsites.com/bus/primitivesoftware/
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;AM Sternquot; wrote:
gt;
gt; gt; I need to sort by item numbers which conatain both text and numbers. Here is
gt; gt; an example of what I need to sort
gt; gt; 1
gt; gt; 2
gt; gt; 1X
gt; gt; 2X
gt; gt; 25
gt; gt; 25X
gt; gt; 26
gt; gt; 112
gt; gt; 113
gt; gt; 112X
gt; gt;
gt; gt; I need it to sort like this:
gt; gt; 1
gt; gt; 1X
gt; gt; 2
gt; gt; 2X
gt; gt; 25
gt; gt; 25X
gt; gt; 26
gt; gt; 112
gt; gt; 112X
gt; gt; 113
gt; gt; the best I have been able to do is:
gt; gt; 1
gt; gt; 1X
gt; gt; 112
gt; gt; 112X
gt; gt; 113
gt; gt; 2
gt; gt; 2X etc.