How To Fix New England, New Jersey, and Caribbean Zip Codes in Excel

Assuming the zip codes are in column E, place the following code in column F:


Drag the formula down the column.

If you want to know why this works, click here.

If you want to know why this problem exists, click here.


Related books picked - and if possible read - by me. Sponsored by Amazon Associates.