Forum Discussion
Excel Help - Zipcode Extraction
Hello! I am having issues extracting zipcodes from a large database of primary addresses. The zipcodes are in varying locations within the address information, but are always 5 digits. For ...
Provided you are a 365 user, you are in luck because Regular Expressions are coming available.
= REGEXEXTRACT(address, "\b\d{5}\b")If you wish to pick out multiple matches or combine it with extracting 7 digit zips that too is possible.