Swapping two words around in teh one cell

C

Christie

I have two words in one cell that I need to swap and place in another cell eg
Allan Smith and would like it to say Smith Allan and then place them in two
seperate cells.
 
Top