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