Splitting an address from one cell into many cells (Australian Addresses)

I have a database of addresses within Australia.
it is like:

123 Smith Road Jonesville Victoria 3000

Is there a macro or script available to split the addresses from one cell into 6 ?
The data is separated by either one or two spaces, so I think the search would be for any space (or two spaces) then place text into a separate cell. I need this to run across the page, the entire address is located in Column D and I require the outcomes to start from column J then K, L, M, N and O respectively.

Column J would then = 123
Column K would then = Smith
Column L would then = Road
Column M would then = Jonesville
Column N would then = Victoria
Column O would then = 3000

I hope someone can help, I have almost 5,500 addresses to sort. The Post Codes are my starting point and this is how I believe I can solve my problem.

Hi Christopher,

I would suggest you to use Text-To-Column inbuilt feature of MS Excel and check the checkbox against 'space' in wizard when asked.

Regards,
DILIPandey

<click on below 'star' if this helps>