#1
|
|||
|
|||
Sorting Names
Have a long list of names with firstname first. I'd like to have the list with lastname first. What's a quick way to sort this sort of text? Most of the names have no middle name/initial. |
#2
|
||||
|
||||
There is no sort process for this. If the names are in a table, with separate columns for given & surnames, you could rearrange the columns; otherwise you could try swapping the names around using a wildcard Find/Replace, but that would be problematic with names that have a middle name/initial or multi-word surnames.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi,LargeAllen
Do you mean that you want to sort the list by last names? If yes, may be you can try to set options in “Sort” feature: 1. select all names-->click “Home”-->click “Sort” in “Paragraph” group, it will open the “Sort Text” dialog box. 2. click “Options” button to open the “Sort Options” dialog box 3. select “Other” under “Separate fields at”, and press key “Blank” once in the text box beside it. 4. on “Sort Text” dialog box, Choose “Word 2” for “Sort by”--> choose “Text” for “Type”--> choose a sorting order, click ok Or as above reply ,you have to convert text to table, then sort them. |
#4
|
||||
|
||||
If you read the original post, that is not what was asked for. What the OP wants is to swap the surname/given names order within a given paragraph. As I already said, though, there is no simple way of doing this when there may or may not be two or more given names and/or multi-word surnames.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting | gilmourlead | Excel | 3 | 02-17-2016 09:27 AM |
Sorting | texascpa | Excel | 1 | 07-15-2015 12:22 AM |
matching names in column A with names in column C | bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
Problem sorting names alphabetically? | mikehende | Excel | 12 | 09-12-2012 12:00 PM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |