How to make an Excel record sorted alphabetically, but you ignore the word “the”?
concern of chicagogurl8 : How to make an Excel list sorted alphabetically, but dismiss the word “the” I have this Microsoft Excel listing of the videos, but I do not want motion pictures like The Departed to be with all the other “T” films. I would not only not Depart Out All the “the” s. How do I make Excel ignore? Several thanks Finest Response:
response from Don R
Attempt this: If your record is in column A, then insert a blank column B. If the initial title is in A1 then enter this method in B1: = IF (Still left (A1, four) = “the”, Proper (A1, LEN (A1) -4), A1) Fill stop now to the bottom of the checklist. What that means is look for the word “the” beginning of a title and if so, it will cover the initial 4 characters to the left and permit your film title, as you know a wollen.Nun Knowledge / Kind with Column B as the sorting standards, and make confident equally column A and B in the sort.

