Switching word order within cells

B

BB&T

Is it possible to switch the order of words within cells, for example if I
have Alexander Todd can I change it to be Todd Alexander? Thanks for the
help!
 
A

Alex Delamain

Try this

=MID(A1,FIND(" ",A1)+1,72)&" "&LEFT(A1,FIND(" ",A1))

It will work as long as the text has two words separated by a spac
 
Top