Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

Use a "helper" column........with your data in column A, in B1 enter:

=--MID(A1,4,9999) and copy down

Then sort cols A & B by B.

share|improve this answer
    
That's what I do. @Gary Is there another way to do this? – Vinay Challuru Mar 1 '14 at 6:22
1  
You could create a macro to do the same type of logic..............this would avoid the need for a "helper column" – Gary's Student Mar 1 '14 at 12:39

An addition to Gary's solution,

=Mid(A1,SEARCH("/",A1)+1,999)

will work for any length behind the slash (just in case someone else finds that helpful)

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .