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

C

Christie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Swapping two word and placing them in another cell 1
Swapping two words around in teh one cell 1
Swapping two words in one cell 2
Auto Fill Word Documents 4
Designate font as italic of another 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Merging from an Excel file with graphics 1
Place picture in Excel cell 0

Top