Parabola
How it WorksWho it's ForFeaturesExamplesLearn
Y

Expanding state abbreviations

Expand or contract US state abbreviations to create addresses

Expanding state abbreviations

Objective

Switching between abbreviations and full names of States can be useful when transferring address data, yet it can be labor intensive. In Excel you may use a VLOOKUP, and in SQL you may use a JOIN.

Solution

Using provided data that has both the long form and abbreviations of states makes adjusting your data as simple as using the Join Object to add key data directly to your data. Just choose if you want to match along the abbreviation or the full name.

Start automating with Parabola
Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.