Forum Discussion
BennettM930
Jul 15, 2024Copper Contributor
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 ...
HansVogelaar
Aug 11, 2024MVP
A very late response...
Are you sure there will never be a five-digit house number? If so: with an address in A2:
=LET(T, A2, L, LEN(A2), S, SEQUENCE(L), N, CONCAT(--ISNUMBER(--MID(T, S, 1))), P, FIND("11111", N), MID(T, P, 5))