| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel alphanumberic sort
Although this is similar to previous posts, it is different enough that
earlier solutions did not resolve my problem. I am sorting a list of part numbers. They are in a three-part format -- prefix, base, suffix. The base is always numeric. The prefix and suffix are alphabetic. A number may be comprised of one, two, or all three of the sections. I want the numbers sorted by base first, then by prefix and then by suffix. See a portion of my list below: 100MS 1577 200322 200861 200886S 202CCAG 40MPB 40MS 40MST 8984YY 90MS AEL0801H CDS211TTRW DC216TTRB DS206GG P90R PAWT214RA PNR112R WPS207GRC WPSH115RRC I want the 40xx numbers to come before 100MS and before 1157. Can this be done in Excel 2003? Thanks for any help you can give me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort from SQL view does not sort in EXCEL | Excel Discussion (Misc queries) | |||
| Does Excel support Alphanumberic formulas? | Excel Worksheet Functions | |||
| Custom Format alphanumberic value with spaces | Excel Worksheet Functions | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
