How change name list from John Smith to Smith John

[Guest]

I have a very long list of names in form John Smith; one name per line. I
want to sort by surname in alphabetic order. Is there a quick way I can
reorder each line to put surname first? If not in Word, could I do this in
Excel or other MS application?

 

[Graham Mayor]

You can do it with replace - see the examples at
http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Luc]

Mike,
Have a look at this article, scroll till you see The practice, Example 1
Transpose first name and surname.
http://word.mvps.org/faqs/general/UsingWildcards.htm

 

[Guest]

You can also sort on the surname without re-ordering each line. I recently
learnt this trick from Suzanne S. Barnhill. Select the list, and go to Table
| Sort. In the drop down Sort by box select Word 2. Job done!

 

[Guest]

Thanks for the pointer. This gives me plenty to work with. Also opened some
new avenues I've not explored before
Regards
Mike R

 

[Guest]

Thanks for the pointer. This gives me plenty to work with. Also opened some
new avenues I've not explored before
Regards
Mike R

 

[Guest]

Thanks for this. Still working on this one but looks hopeful for my query -
and some related queries.
Mike R