Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Arranging Document Windows

Specifying a Backup Location

Controlling Chart Gridlines

Merging Table Cells

Collapsing and Expanding Subdocuments

Zooming With the Keyboard

Initiating a New Search

 

Changing Sort Order

Summary: Word sorts data very quickly, but it doesn't sort it in the same way that humans would sort it. This can lead to problems when putting together traditionally sorted material, such as indexes. This tip illustrates the problem and discusses how you can work around it. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

When Word sorts information, it does so according to the underlying codes used to represent characters on the screen. PCs (and most other small computers, such as the Macintosh) use the ANSI character set, or perhaps the Unicode character set. Regardless of which set is used, each character is assigned a unique numeric value. This assignment is done because computers can only manipulate numbers, not characters.

When sorting, Word is actually sorting information based on the underlying character codes, not on characters themselves. For instance, the ANSI character code for the letter C is 67, and the value for B is 66. By sorting the character codes in ascending order, B will always come before C.

This can lead to some problems when it comes time to sort some types of text. For instance, you may be creating a glossary, index, or bibliography, and you want "Brother, Charles" to come before "Brother Roberts" (in other words, you want the comma ignored during sorting). Unfortunately, you can't do that in Word--sorting is done as already described. While the first seven characters of each term ("Brother") match, the space will always be sorted before the comma. Why? Because the space has a lower numerical character code than does the comma.

The same sort of problem arises when sorting terms that contain abbreviations, such as "St. Charles" and "Saint Jerome." In traditional literary indexes, "St. Charles" would appear before "Saint Jerome." In mechanical indexes (an index sorted by a computer program such as Word is referred to as a mechanical index), the opposite is true because the "t" in "St." comes after the "a" in "Saint".

If someone is bound and determined to develop a list of text sorted in the grand literary style, then the only solution is to do it by hand or to use some work-around process. For instance, you could write all instances of "St. Charles" as "Saint Charles," but format "Saint" in such a way that after sorting you could easily find it (using Word's replace feature) and replace it with "St."

This is obviously a lot of work, particularly if you are dealing with a large amount of text. For this reason, many publishing houses (particularly those that publish technical non-fiction works) find using mechanical indexes quite acceptable. Those who prefer the traditional literary approach, however, are out of luck when it comes to Word.

Tip #1537 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003

Find and Replace Almost Anything! An invaluable resource for learning how to harness the full power of Word's search and replace capabilities. You'll discover everything you need in order to master all the intricacies of finding and replacing elements of your document, including the super-powerful "wildcard searches" available in Word.
 
Check out WordTips: Find and Replace today!