| 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? |
| 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) | |||
Threaded Mode
