| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aplpha Numeric Mixed Sorting
I have some part numbers. They are all 10 digits. But it could be a pure 10
digit number like "9150000001", but also could be any kind of mix up of apha and numeric like "853TT00123", or "A00008299X". I want them to be sorted like this way: 853TT00123 8540000587 90000HH223 9150000001 915000000X What I meant is that it sort digit by digit - It sort by the first digit, then the 2nd digit, then the 3rd... then the 10th. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Alpha-Numeric Values | Charts and Charting in Excel | |||
| Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions | |||
| Sorting Alpha Numeric | Excel Discussion (Misc queries) | |||
| Alpha-Numeric Sorting | Excel Discussion (Misc queries) | |||
| Sorting mixed up linked cells in a workbook? | Excel Worksheet Functions | |||
Threaded Mode
