J
Jude
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
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