switch text order in a cell

[Guest]

How would I change the text order in a cell (either through word or excel).
For example the text is: Smith, James. I would like to switch it to James
Smith.

 

[Suzanne S. Barnhill]

See http://word.mvps.org/FAQs/TblsFldsFms/SplitFirstNameLastName.htm, which
will help you split the names. You can then swap the columns or sort by
either one.

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