Skip to main content

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

Author: Xiaoyang Last Modified: 2018-08-31

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


Best Office Productivity Tools

Kutools for Word - Elevate Your Word Experience with Over 100 Remarkable Features!

๐Ÿค– Kutools AI Assistant: Transform your writing with AI - Generate Content  /  Rewrite Text  /  Summarize Documents  /  Get Quick Answers, all within Word

๐Ÿ“˜ Document Mastery: Split Pages  /  Merge Documents  /  Export Selection in Various Formats (PDF/TXT/DOC/HTML...)  /  Batch Convert to PDF  /  Export Pages as Images  /  Print Multiple Files at once...

โœ Contents Editing: Batch Find and Replace across Multiple Files  /  Resize All Pictures  /  Transpose Table Rows and Columns  /  Convert Table to Text...

๐Ÿงน Effortless Clean: Sweap away Extra Spaces  /  Section Breaks  /  All Headers  /  Text Boxes  /  Hyperlinks  /  For more removing tools, head to the Remove group...

โž• Creative Inserts: Insert Thousand Separators  /  Check Boxes  /  Radio Buttons  /  QR Code  /  Barcode  /  Diagonal Line Table  /  Equation Caption  /  Image Caption  /  Table Caption  /  Multiple Pictures  /  Discover more in the Insert group...

๐Ÿ” Precision Selections: Pinpoint Specific Pages  /  Tables  /  Shapes  /  Heading Paragraphs  /  Enhance navigation with more Select features...

โญ Star Enhancements: Navigate to Any Location  /  Auto-Insert Repetitive Text  /  Toggle Between Document Windows  /  11 Conversion Tools...

๐Ÿ‘‰ Want to try these features? Download Kutools for Word now! ๐Ÿš€
 
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations