How to extract state, zip code or city from address in Excel?

This is an Open Educational Resource (OER) provided by the GFE Foundation. It is a supplementary asset for the document EXCEL CONVERT ZIP TO STATE . Feel free to use this material in your classrooms and presentations.