How do I get Excel to ignore 'the' when sorting titles?

bob1

Active member
Joined
May 12, 2008
Messages
1,779
Reaction score
0
Points
36
I have Microsoft Excel 2007 and I'm currently making a list of games I own on it, I want it sort alphabetically by title but when I do it just shoves every game that starts with 'the' in the T's. How do I get it so that it would sort say for instance "The Ship" with the S's instead of the T's?
 
Back
Top