Data extraction from a cell into multiple

Dear Sir,

I have address data in a column in a single cell, I just want to seprate it as "Street" City, Zip, and Country.

I have attached a sample sheet for reference with the desired result.

Thanks in advance, really appreciate your help.

Please try at
E2
=SUBSTITUTE(LEFT(A1,FIND(",",A1)-1),F2,"")
D2
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(",",A1)-1)," ",REPT(" ",20)),20))

G2:I2
=MID(MID($A1,FIND(",",$A1)+2,90),INDEX({1,4,15},COLUMNS($G2:G2)),INDEX({2,10,15},COLUMNS($G2:G2)))


or E2 drag across and down
=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,",",""),TRIM(F2&" "&G2&" "&H2&" "&I2),"")," ",REPT(" ",20)),40*(1+(COLUMNS($E2:E2)=1)*9)))

thank you so much for quick response and solution sir, It's working like a charm.
Is this formula also work in Excel Office 365 ?