Hello, I am trying to make a pivot table with a large amount of different acronyms/number combinations. The problem is I have numbers like TB-1, TB-11, TB-2(3), DW-5(7), DW-6. I really need them to sort in the number after the dash. So it would look in a column in the order like this TB-1 | TB-1(1) | TB-2..............TB-10 | TB-11 and so on. right now it puts 11 before 2, there are 100's of these I need to verify and this would make it so much easier.
Office 365
Office 365