Microsoft KB Archive/195131

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

Article ID: 195131

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q195131





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:


 * 1) 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, only the space (not the non-breaking space) will be used 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.)
 * 1) Select the list.
 * 2) On the Table menu, click Sort.
 * 3) Click Options, select Other, type a space in the text box, and then click OK.
 * 4) 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.
 * 1) On the Table menu, click Sort.
 * 2) 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.

The list is now sorted by last name.

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

Keywords: kbhowto kbualink97 KB195131

-

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

© Microsoft Corporation. All rights reserved.