This article was previously published under Q151447
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
It is possible to sort titles in Microsoft Excel and ignore articles suchas "A," "An," and "The" while sorting. Normally when sorting in MicrosoftExcel, the entire contents of the cell are sorted. It is possible to workaround this by creating a formula that ignores the articles.
When sorting lists that contain the titles of movies, records, or books,most people want to have the list sorted so that any of the initialarticles, such as "A," "An," or "The" are ignored during the sort.
If a normal sort in Microsoft Excel is performed on the following data
A Kiss Before Dying Kiss Me, Kiss Me, Kiss Me The Kissing Place A Kid in King Arthur's Court The Egg and I Kentucky Blue An Egg Named Ed
it would look as follows after the sort:
A Kid in King Arthur's Court A Kiss Before Dying An Egg Named Ed Kentucky Blue Kiss Me, Kiss Me, Kiss Me The Egg and I The Kissing Place
To sort a list that contains titles that begin with one of the initialarticles, follow these steps:
Enter the following data in a worksheet:
A1: Title A2: A Kiss Before Dying A3: Kiss Me, Kiss Me, Kiss Me A4: The Kissing Place A5: A Kid in King Arthur's Court A6: The Egg and I A7: Kentucky Blue A8: An Egg Named Ed