Sorting

[Tomk]

Does Excel 2007 have a built in way to sort a list of names and ignore "The"
in the title?

 

[Dave Peterson]

Nothing built into excel allows this.

You could use a formula in another column to ignore the first word (like The,
An, A, ...) and then sort by that helper column.

 

[JB]

With VBA:

Sub Sort()
Set Start = Range("a1")
Start.Offset(0, 1).EntireColumn.Insert Shift:=xlToRight
For Each c In Range(Start, Start.End(xlDown))
If UCase(Left(c, 3)) = "THE" Then
c.Offset(0, 1) = Mid(c, 5)
Else
c.Offset(0, 1) = c
End If
Next c
Start.CurrentRegion.Sort Key1:=Start.Offset(0, 1),
Order1:=xlAscending, Header:=xlGuess
Start.Offset(0, 1).EntireColumn.Delete
End Sub

http://cjoint.com/?cdrExzkMSs

JB
http://boisgontierjacques.free.fr/