While working on a project today, I ran into a problem with data in a spreadsheet that had the names of states fully spelled out instead of abbreviated. A brief search on the internet for a vba mac…