Sometimes sorting gets really frustrating when all the data you are trying to sort isn’t formatted the same.
Create a new column next to the column you’re attempting to sort, then use this formula to move X amount of characters. I’m using Ford Part #’s and I need to sort by the 4th character in which is the Z
A2 cell = C0AZ-7153-A
|
1 |
=RIGHT(A2,LEN(A2)-x) |
Whereas x = the amount you want to move for example
|
1 |
=RIGHT(A2,LEN(A2)-3) |
which gives
Z-7153-A
From there just copy that formula to the rest of the cells in the new column then u can sort sheet under that column.
