| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Swapping two word and placing them in another 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 seperate cells. How can I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Swapping two word and placing them in another cell
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 --- "Christie" wrote: 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? |
| 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 two words in one cell | Excel Worksheet Functions | |||
| Placing word into a seperate cell | Excel Discussion (Misc queries) | |||
| I am placing a pie chart into word. When viewing/printing it look. | Charts and Charting in Excel | |||
Linear Mode
