Parabola
How it worksFeaturesExamplesUse CasesPricing
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.

Ready to get started?
Try it now for free, no credit card required