| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
If you don't need it all in one column and all of the numbers are the same
format, you could go to data then text to columns and have the delimitor be /, then sort by the 2nd new column. "MikeInPortland" wrote: i have hundreds of cells containing: (Example:#103 / 4 / 23) or (#105 / 3 / 17 ) ... how can I convert these cells to sort by the second number value; the 3 or 4 in the example ... Much Thanks !! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Sort by column problems | Excel Worksheet Functions | |||
| How to sort but keep linked formulas? | Excel Discussion (Misc queries) | |||
| Can I sort values only & leave orginal cell formatting? | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
