github twitter rss
Google Sheets formula to convert US State abbreviations
Jul 29, 2015
1 minute read

I had a simple problem yesterday. I was trying to import a spreadsheet of contacts into Salesforce, but the states in the addresses were all written as the abbreviations, when Salesforce wanted the full names.

Seemed like a simple enough problem, but I couldn’t find a way to convert these easily. Being a stupid programmer, I thought I’d just make one. I only pushed it far enough to do the job. I didn’t get it listed in the Google add-ons or anything, but went ahead and made a GitHub repo for it here: https://github.com/davegaeddert/google-sheets-us-states

demo


Back to posts