[mike1234robe]

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
Word MVP web site http://word.mvps.org


mike1234robe wrote:
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?

[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

--
Luc Sanders
(MVP - PowerPoint)
"mike1234robe" schreef in bericht
...
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?

[Rae Drysdale]

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!
--
Rae Drysdale


"mike1234robe" wrote:

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?

[mike1234robe]

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

"Graham Mayor" wrote:

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
Word MVP web site http://word.mvps.org


mike1234robe wrote:
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?

[mike1234robe]

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

"Luc" wrote:

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

--
Luc Sanders
(MVP - PowerPoint)
"mike1234robe" schreef in bericht
...
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?

[mike1234robe]

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

"Rae Drysdale" wrote:

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!
--
Rae Drysdale


"mike1234robe" wrote:

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?