Hi,

I am working with Addresses on this one.

format sample: 1 High Street Sydney NSW 2000

I would like to extract:
"1 High Street" in a different column
"Sydney NSW 2000" in a different column

Appreciate any help