| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| How to sort text as numbers | Excel Discussion (Misc queries) | |||
| How can I sort by numbers and not text? | Excel Worksheet Functions | |||
| sort text as numbers excell2003 to 2000 | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Threaded Mode
