Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to know how to sort a group of numbers that have a different amount of
digits in them and may have dashes and letters. I have tried formatting the cells as numbers, text, and general. None of that works. It always comes up with the 3 digit numbers first, then 4 digit, then 5 etc. I need to be able to sort it by 1st digit, then 2nd, then 3rd, etc. Example 112 1134-blk 112563 1290-wht 1345 150 80-17068-03 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting in Excel | Excel Discussion (Misc queries) | |||
excel sorting | Excel Worksheet Functions |