Ignoring the Articles A, An, and The When Sorting Titles (151447)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q151447 SUMMARY
It is possible to sort titles in Microsoft Excel and ignore articles such
as "A," "An," and "The" while sorting. Normally when sorting in Microsoft
Excel, the entire contents of the cell are sorted. It is possible to work
around this by creating a formula that ignores the articles.
REFERENCESMicrosoft Excel 97
For more information about sorting data, click Contents And Index on the
Help menu, click the Index tab in Excel Help, type the following text
and then double-click the selected text to go to the "sort a list" topic.
If you are unable to find the information you need, ask the Office
Assistant.
Microsoft Excel 7.0
For more information about sorting data in Microsoft Excel, click Answer
Wizard on the Help menu and type:
Microsoft Excel 5.0
For more information about sorting data in Microsoft Excel, click the
Search button in Help and type:
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | kbhowto KB151447 |
---|
|