| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Swapping two words in a cell and placing them in another cell
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Swapping two words in a cell and placing them in another cell
See 'here' (http://tinyurl.com/cutbfj) -- 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=62824 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Swapping two words around in teh one cell | Excel Worksheet Functions | |||
| Placing Col & Row identifiers into a cell as text | Excel Worksheet Functions | |||
| Placing word into a seperate cell | Excel Discussion (Misc queries) | |||
| how do I Change cell fill colour by placing letter in it | Excel Discussion (Misc queries) | |||
| Can I change the format of one cell by placing a tick in another? | Excel Discussion (Misc queries) | |||
Hybrid Mode
