How to split a cell by case

[mayhem]

Dear Chandoo

What's the best formula to split a cell by case. In the below example, how do I separate 15 Potts St from RYDE NSW 2112.

15 Potts St RYDE NSW 2112

Thank you

 

[NARAYANK991]

Hi ,

See if this works on other data.

Narayan

 

[mayhem]

Thank you Narayan, you're the best