Problem: I want to sort part #'s by type, but the # comes first so if I sort it will go by the parts number.
ex: Srg000241-A500
Srg000356-B3779
where A500=machine 1 and B3779=machine 2
I have a bunch of those parts and they all end in -_____. I want to sort by what comes after the dash. My idea was to search the cell for the dash, copy everything that comes after the dash and then paste it into a row of empty cells and then sort by this new row.
Can anyone help with this code?
Thanks!
ex: Srg000241-A500
Srg000356-B3779
where A500=machine 1 and B3779=machine 2
I have a bunch of those parts and they all end in -_____. I want to sort by what comes after the dash. My idea was to search the cell for the dash, copy everything that comes after the dash and then paste it into a row of empty cells and then sort by this new row.
Can anyone help with this code?
Thanks!