Forumula for address list - Really struggling with this one

Hi Guys,

I'm really struggling to find help to for this

I have a list of addresses I’d like to put in an excel spreadsheet document.

I have very little experience of excel formulas.

I’m trying to have find a formula that is able to re-arrange these in the columns I’ve provided.

Please see sample attached.

Hope someone can help with this.

Kind Regards

Marc Thomas