Swapping two words in a cell and placing them in another cell
I have two word in one cell and would like to 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 seperate cells.
How can I do this?
|