Split column

Hey everyone. I need some help with my excel forumula. Actually I dont even know where to start with this. Can be solved in 2 ways

1st way : I have 2 columns where one has the postal code and that postal code has to placed inside the second column in a specific place, after the full street name. Text inside the column has different lenght and numer of words. (Postal code has always the same lenght)

2nd way: I want the City name to be deleted (wchich is different) but always is the last word in the column but thre are different lengths of the text in the column .


Exact example in the attachment here to download

Thank you in advance

Nowy Microsoft Excel Worksheet (2).xlsx