Separating text

[Bonnie]

If we copy text from an Excel spreadsheet and want to
separate the first name from the last name so we can
reverse the order, is there an easy way to do this? I
tried going to Table, Sort and clicking on the Options
button. The Other, Commas, and Tabs options are grayed out.

Thanks,

Bonnie

 

[Graham Mayor]

See if the examples at http://www.gmayor.com/replace_using_wildcards.htm
help

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


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

 

[Suzanne S. Barnhill]

See http://word.mvps.org/FAQs/TblsFldsFms/SplitFirstNameLastName.htm