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

My web site www.gmayor.com

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

 

[Suzanne S. Barnhill]

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.