Formatting Zip+4 Codes
Friday, January 25th, 2008 3 viewsIf you have a column of zip+4, this macro will remove the suffix. Simply highlight the cells in question. It will skip any zip codes that don't have the suffix. It uses the Left$ string function which is more efficient than the standard Left() and always returns the first 5 ...
