I have a column in Excel with entries like
TI/303
BA/045
BA/009
AB/123
I would like to sort it by the numbers ignoring the first three characters like
BA/009
BA/045
AB/123
TI/303
How can I achieve such a custom sorting in Excel?
I have a column in Excel with entries like
I would like to sort it by the numbers ignoring the first three characters like
How can I achieve such a custom sorting in Excel? 


Use a "helper" column........with your data in column A, in B1 enter:
Then sort cols A & B by B. 

