I am having issues with the sorting of catalog numbers.
I currently have a "country" Column B(sorted first) then a "number" Column C that can vary with letters or dash. As of now it almost sorts correctly but I need it to go in this order. what seems to be out of place are the numbers with the dash in between. I desperately need a fix to put them in place. With over 125,000 pieces of inventory I can't move it one by one. Please help.
1
2
3
3-7
5
3a
9
13
13-19
14
14c
20
20f
115
170
1007
C5
C22
C22a
Bookmarks