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?

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?

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" <(E-Mail Removed)> schreef in bericht
news:1CA9D643-B436-43FA-B7B4-(E-Mail Removed)...
>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?

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?

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?
>
>
>

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" <(E-Mail Removed)> schreef in bericht
> news:1CA9D643-B436-43FA-B7B4-(E-Mail Removed)...
> >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?
>
>
>

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?