Hello all,

I have a spreadsheet with 15000 addresses in a column and these addresses have both 5 digit and 11 digit zip codes. I would like a column with all 5 digit zip codes.

I currently use the formula =LEFT(A1,LEN(A1)-6) to convert 11 digit zips into 5 digits but I would like a formula that first checks the length of the zip code before performing the function.

Thank you for you time


Zip Code Sample.xlsx