Address/Postcode seperate

Hello,

I have a problem where address data on a sql database is quite messy. When copying to excel, it looks as per the sample attachment. Is there a formula to clean this up or to just even seperate the postcode only from the address column?

As you can see, some of the addresses are seperated by comma, normal spacing, double spacing etc. I have about 5000 rows to clean this up.

Any help would be much appreciated.

Thank you