View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AM Stern
 
Posts: n/a
Default 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.