Swapping two word and placing them in another cell

C

Christie

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 seperate cells.

How can I do this?
 
M

Max

One play
Assuming data in A2 down, with a single space between words
this directly gives you the final output (Smith in B2, Allan in C2)
In B2: =RIGHT(TRIM(A2),LEN(TRIM(A2))-SEARCH(" ",TRIM(A2)))
In C2: =LEFT(TRIM(A2),LEN(TRIM(A2))-SEARCH(" ",TRIM(A2)))
Copy B2:C2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
 

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 words in one cell 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Excel Comparing two columns 1
Trim a cell that has names and address to only show name 8
add two cells from seperate work sheets into a cell on seperate wo 6
Finding the number of times a word is used in a range of cells 8
Return cell characters after space 2

Top