June 21, 2024


Welcome to the core

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
Copyright © All rights reserved. | Newsphere by AF themes.