This video will teach you how to troubleshoot an address list in Excel. Learn a formula trick to deal with missing zeros in zip codes. Also perform a vlookup to find state abbreviations. And you will learn how to format proper case for names.