Excel predicament

Discussion in 'DVDR' started by squijello, Aug 25, 2006.

  1. squijello

    squijello Regular member

    Joined:
    Mar 15, 2004
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    26
    I have a list of movies that I own in an excel document... however what i have found is that any movie that has the in the title, i.e, the matrix, the sixth sense, etc., are all together in order... is there a way to tell excel not to take into consideration the 'the' and instead go based on the following word?
     
  2. laddyboy

    laddyboy Regular member

    Joined:
    Jan 4, 2005
    Messages:
    3,699
    Likes Received:
    0
    Trophy Points:
    46
    Why not just remove "the" from the starting position:

    sixth sense, the
     

Share This Page