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?

Swapping two words in a cell and placing them in another cell
 

See 'here' (http://tinyurl.com/cutbfj)


--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62824