Split Address with Space

[Blessy Clara]

Please help - How to split this address string

[TABLE="******* 387"]
<tbody>[TR]
[TD="class: xl64, ******* 387"]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[/TD]
[/TR]
</tbody>[/TABLE]

Samples
[TABLE="******* 387"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1 /650 Burwood Road HAWTHORN EAST VIC 3123[/TD]
[/TR]
[TR]
[TD]1 10A Atherton Road OAKLEIGH VIC 3166[/TD]
[/TR]
[TR]
[TD]1 3A Takalvan Street BUNDABERG QLD 4670[/TD]
[/TR]
[TR]
[TD]1 48 George Street BEENLEIGH QLD 4207[/TD]
[/TR]
[TR]
[TD]1 Bangalow Road BALLINA NSW 2478[/TD]
[/TR]
[TR]
[TD]1 Beach Road AYR QLD 4807[/TD]
[/TR]
[TR]
[TD]1 Chale Ct BUNDALL QLD 4217[/TD]
[/TR]
[TR]
[TD]1 Cypress Place WALLERAWANG NSW 2845[/TD]
[/TR]
[TR]
[TD]1 David Street OLD BAR BEACH NSW 2430[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.