I have two words in one cell and would like to swap them and place them in
another cell eg Allan Smith and I would like it to say Smith Allan.

Once this is done I would then like the two words into two seperete cells.

How can I do this?