Extract Postcode From Cell

This formula will extract the postcode from a cell, if the address is all in one cell to start with. 
 
=MID(C2,FIND(“@”,SUBSTITUTE(C2,” “,”@”,LEN(C2)-LEN(SUBSTITUTE(C2,” “,””))-1))+1,255)
 
It basically extracts the last 2 strings from a cell, and in most cases for the data we are using this pulls out just the postcode. 
 
Special Thanks to #KDog