Cut and paste specific data

[Father John]

`Hi
Have been working on a problem which I think I can now simplify

Cell A1 contains the following:
15 Smith Street Blacktown
How can I cut the last item (Suburb) from the cell and paste it into B1?
Many thanks in advance
Stephen

 

[RagDyer]

Try this in B1:

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

 

[John]

Hi Father John
Have you tried >Data>Text to Columns : > Select "Fixed Width" then remove excess
line break by double clicking on them.
HTH
John