| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Swapping two words in one cell
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Swapping two words in one cell
Try this...
=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)) -- Rick (MVP - Excel) "Christie" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Swapping two words in one cell
=RIGHT(E12,LEN(E12)-SEARCH(" ",E12)) & " " & LEFT(E12,SEARCH(" ",E12)-1) You can put it into two cells by using the Right and Left parts of the code separately. -- 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=62831 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Swapping two words in a cell and placing them in another cell | Excel Worksheet Functions | |||
| Swapping two words around in teh one cell | Excel Worksheet Functions | |||
| Swapping Cells in Excel | Excel Discussion (Misc queries) | |||
| Swapping Rows & Columns | Excel Discussion (Misc queries) | |||
| swapping columns?? | Excel Discussion (Misc queries) | |||
Linear Mode
