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.

See http://word.mvps.org/FAQs/TblsFldsFm...meLastName.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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"sue" wrote in message
...
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.