Hi All! I own a business and find myself facing a VERY critical project that needs to get done ASAP! Basically I have a column in excel (2016 version) that reads State Names, and Territory Names that need to be converted into State/ Territory Abbreviations.

Example:

Column A Column B
Arizona, Michigan > I need to read: AZ, MI
U.S. Northeast > I need to read: NJ, NY, PA

How can I write a function or use an add-in (assuming these are correct to consider?) to make this conversion possible!? It's really critical to get this correct so my business can continue to grow! I will really appreciate your input and advice on this matter!