Select the cell first and then go to Data| text to column| , choose
Fixed Width option...








On Mar 25, 4:08*am, Jude wrote:
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