Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to sort full names based on the last name in Word document?

In Word document, we can quickly sort a list of names alphabetically by using the Sort function, and all the names will be sorted by the first name. But, have you ever tried to sort the full names based on the last name in Word?

Sort full names based on the last name with Sort function in Word document


Sort full names based on the last name with Sort function in Word document

In Word document, to sort a list of names by last name, please do with the following steps:

1. Select the names list, and then click Home > Sort, see screenshot:

doc sort by last name 1

2. In the Sort Text dialog box, click Options button, see screenshot:

doc sort by last name 2

3. In the Sort Options dialog box, in the Separate fields at section, select the separator that between the names, in this case, I will choose Other option, and then type a space into the box, see screenshot:

doc sort by last name 3

4. Then click OK to return the Sort Text dialog, here, you should select Word 2 from the Sort by drop down list, and then specify the sort order as you need, see screenshot:

doc sort by last name 4

5. And then click OK to close the dialog box, and now, you can see the full names have been sorted by the last name as following screenshot shown:

doc sort by last name 5


Recommended Productivity Tools

shot kutools word kutools tab 1180x121
shot kutools word kutools plus tab 1180x120
 

Kutools For Word - More Than 100 Advanced Features For Microsoft Word, Save Your 60% Time

  • Complicated and repeated operations can be done a one-time processing in seconds.
  • Insert multiple images across folders into Word document at once.
  • Merge and combine multiple Word files across folders in to one with your desired order.
  • Split the current document into separate documents according to heading 1, section break or other criteria.
  • Convert files between Doc and Docx, Docx and PDF, collection of tools for common conversions and selection, and so on...
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.