Ignore "a(n)", "the" in A-Z sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm sure it's easy, but I can't find this anywhere. I need to sort, ignoring
A, AN, THE, so everythging is in the correct alphabetical order. Any help?
 
A Bob Phillips suggestion from Nov. 13th

Create a helper column and strip leading The and A and An,

=Substitute(Substitute(Substitute(A1,"The ",""),"A ",""),"An","")

Sort on the stripped column.


Gord Dibben MS Excel MVP
 
Create a helper column and strip leading The and A and An,

But is it possible for them to remain, but still be sortable, just ignoring?
 
They will remain in the original column. Select all the relevant columns
(including the original and the helper column), sort by the helper column,
and that will sort the original ignoring the bits you've stripped out.
 
Back
Top