Macro 50: Truncate ZIP Codes to the Left Five
Macro 50: Truncate ZIP Codes to the Left Five U.S. ZIP codes come in either 5 or 10 digits. Some systems output a 10-digit ZIP code, which, for the purposes of a lot of Excel analysis, is too many. A common data standardization task is to truncate ZIP codes to the left five digits. Many […]
Macro 50: Truncate ZIP Codes to the Left Five Read More »