Split Address with Space

[Blessy Clara]

Please help - How to split this address string

1 /650 Burwood Road HAWTHORN EAST VIC 3123 From Right Using Space First space in one column = Zipcode (3123) Next Space in another column = City (Vic) Next Space in Another column = Hawthorn East

<tbody>
</tbody>

Samples

1 /650 Burwood Road HAWTHORN EAST VIC 3123

1 10A Atherton Road OAKLEIGH VIC 3166

1 3A Takalvan Street BUNDABERG QLD 4670

1 48 George Street BEENLEIGH QLD 4207

1 Bangalow Road BALLINA NSW 2478

1 Beach Road AYR QLD 4807

1 Chale Ct BUNDALL QLD 4217

1 Cypress Place WALLERAWANG NSW 2845

1 David Street OLD BAR BEACH NSW 2430

<colgroup><col></colgroup><tbody>
</tbody>

 

[mohan.r1980]

thank you for your effort.

your welcome

 

[jitendraxl]

You can use Data>Text to Columns>Delmited>Choose delemitor of your choice as you find in data. Space in your case and data will split in the next columns.