Switching words within cells

T

Todd

Is it possible to switch the word order within a cell. For example, if I
have Alexander Todd in cell A1, can I change it to Todd Alexander? Thanks
for the help!
 
G

Guest

hi
=SUBSTITUTE(MID(A1,FIND(" ",A1)+1,255)&" "&LEFT(A1,FIND
(" ",A1)),"/"," & ")
Switch the cell address to your cell address
 
Top