Microsoft KB Archive/153671

= WD: How to Sort Words Separated by a Space =

Article ID: 153671

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 98 for Macintosh
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 6.01 for Macintosh

-



This article was previously published under Q153671





SUMMARY
This article describes how to sort information that is separated by spaces, such as a list of names.



MORE INFORMATION
To sort information that is delimited by spaces, follow these steps:   Confirm that each row contains the same number of fields. For example, if you are sorting a list of names and some names include a middle initial while others do not, the sort is not completed correctly.

NOTE: If you add a non-breaking space between some fields and use the SPACEBAR for others, and then sort on a space, it will only use the space (not the non-breaking space) to sort. For example, if you want to sort on last names, but your data includes honorifics or middle initials, insert non-breaking (CTRL+SHIFT+SPACEBAR) spaces in the following positions:      Dr. Andrew Gray  (This will sort on the space                                         between Andrew and Gray.) Andrew Gray ,MD  (This will sort on the space                                         between Andrew and Gray.) Andrew P. Gray (This will sort on the space                                         between P. and Gray.)  Select the list. On the Table menu, click Sort. Click Options, select Other, type a space in the text box, and then click OK. Click OK again.

NOTE: This closes the Sort Text dialog box, which will not list all of the fields to sort by until you reopen the dialog box. On the Table menu, click Sort.</li> In the Select By list, select Word 2 (or another field you want to sort by), choose a Type, select Ascending or Descending order, and then click OK.</li></ol>

The list is now sorted by last name.

Additional query words: space delimit delimited blank blanks delimiters 8.0 8.00

Keywords: kbhowto kbualink97 KB153671

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.