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 ...
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))