Perhaps the functions in my litLIB Excel functions library can help.

See:
http://www.oraxcel.com/projects/litlib/
and
http://www.oraxcel.com/cgi-bin/yabb2...num=1133444908

To swap two words you could do the following:

A1: Joe Bloggs

A3: =Concatenate( WordsRight(A1,1), " ", WordsLeft(A1,1))

If you have more than two words you can use the WordsMid function:

A1: "This is great"

A3: = Concatenate( WordsMid(A1,3,1), " ", WordsMid(A1,2,1), " ",
WordsMid(A1,1,1) )

Hope this helps,

Gerrit-Jan Linker
www.oraxcle.com