| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort a cell by last two digits
I am trying to sort my colum by the last two digits of the number in each cell.
EX: 50201.1001 50201.1002 50201.1003 50201.2001 50201.2002 50201.2003 50201.3001 50201.3002 50201.3003 I want to sort by the last two digist of 01,02,03 of my column. Does anyone have any idea how to do this. Or if it is even possible. If you do please can you explain to me step by step what I will have to do to accomplish this task. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort by numbers of digits in cells | Excel Worksheet Functions | |||
| How do I sort the last 3 digits first and then the first 4 digit?. | Excel Worksheet Functions | |||
| How do I sort different combination of a 4 digits number | Excel Discussion (Misc queries) | |||
| Sort by last 2 digits | Excel Discussion (Misc queries) | |||
| Sort by last 2 digits | Excel Worksheet Functions | |||
Threaded Mode
