| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move part of cell only - help please
It should not be too hard but I am unable to find a solution.
I want to take a specific word from a cell and place it in another. I have in the cells with addresses eg"1955 BOUNDRY ROAD RD 3 AUCKLAND" and I wish to split it to three cells, "1955 BOUNDRY ROAD" "RD 3" "AUCKLAND". If I choose to use the text to colums it puts the data in a seperate cell at each space. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to move part of cell contents to another cell | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| Checkbox not part of cell. (???) Cells can move "underneath". (!!!) | Excel Discussion (Misc queries) | |||
Threaded Mode
