I have a bunch of addresses where the last word of each address needs to be
split. Eg. edgeware road london. I would like edgeware road to stay in its
cell and london to be removed and placed in the cell to the right.

A formula or vba solution would be appreciated.
--
Thanks in advance,
MarkN