I am trying to sort a large tool room list numerically so it can be reorganized. The problem I am running into is have the sheet has numbers only for the tools and the other half the sheet has letters or numbers after the number with a dash (51701-blt). I have seven columns in this spreadsheet:
quantity, tool number, description, section,kit, sort order, notes, and location.
I appreciate anyone's help in this. I want to sort by sort order.
I assume that the problem is that number will be sorted after text, like in this screenshot, is that correct?
When cells contain a mix of text and numbers, text will be sorted after the numbers. If you want to sort strictly by the numerical value, you need to pull the number into a helper column. The formula to do that is showing in cell E12
This now shows me that there is no pattern that we can use in a Left or Mid function by just looking at the dash. Instead, the approach needs to be to use a helper column that extracts all numeric characters from the cell.
Here is the formula that does that to the number in F5 (change accordingly)