| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sorting
i have data in column A that i want to sort by the numbers after the dash.
here is an example of the data. 105487-130 159755-130 156789-140 135444-120 the number behind the dash indicates a ship to location that i want to group this data by. i have about 200 entries in col A and about 5 different types of extensions(the number after the dash). let me know any thoughts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sorting
i figured it out using "test to columns"
thanks "brianb" wrote: i have data in column A that i want to sort by the numbers after the dash. here is an example of the data. 105487-130 159755-130 156789-140 135444-120 the number behind the dash indicates a ship to location that i want to group this data by. i have about 200 entries in col A and about 5 different types of extensions(the number after the dash). let me know any thoughts |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
| SORTING question | New Users to Excel | |||
Linear Mode
