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 |
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 |
All times are GMT +1. The time now is 06:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com