Split cells postcode from address

If I have an address in a cell is it possible to separate the postcode out into a different cell. Unfortunately there are no delimiters I can use from the standard list as the only thing in the address are spaces, but if I use space as a separator it splits up the address and the postcode into two cells. I will have up to 30000 addresses which is why I am hoping there is an answer

Here is an example of what I have and I just want to seperate the postcode from the rest of the address

eg Jo Blogss 123 The Lane Newcity NW12 4EE (one cell)

Result I am looking for

Jo Bloggs 123 The Lane Newcity (one cell) NW12 4EE (another cell)

Thanks

Hi Always at the end of cell but sometimes 7 characters but as the 8th is a space this may work OK. I will givt it a try thanks

This works great apart from there appears to be a space at then end of all the addresses I was given. If I delete the space the formula works fine, anyway to take this into account?

Thank you very much daddylonglegs, sved me about a millikon hours of remedil work

Originally Posted by dsthome

Thank you very much daddylonglegs, saved me about a million hours of remedial work

Thank you very much daddylonglegs, saved me about a million hours of remedial work, next task replace keyboard on laptop half the keys don't work very well.