Move part of cell only - help please
Which would work if all cells had the same information, but it is all
different :-)
Thanks for the quick responce
"Gary''s Student" wrote:
In cell A1 enter:
1955 BOUNDRY ROAD RD 3 AUCKLAND
In cell A2 enter:
=LEFT(A1,17)
In cell A3 enter:
=MID(A1,19,4)
In cell A4 enter:
=RIGHT(A1,8)
--
Gary''s Student - gsnu200775
"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
|