State Abbreviation

Topic Labels: Formulas
6814 7
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have created a base for my classmates to update their contact info. How can I make the state field the 2 letter abbreviation vs the state name spelled out?

7 Replies 7

Could you leave a example? :thinking:

5 - Automation Enthusiast
5 - Automation Enthusiast

Instead of “Indiana” I only want the 2 letter abbreviation “IN”


5 - Automation Enthusiast
5 - Automation Enthusiast

Can you just make the field a single select and enter the two letter abbreviations you want them to choose from?

Actually thought about that but would need to enter all 50. Thought there might be a quicker way.

But, you only have to do it once.

It’s actually not that hard to do:

  1. Create a new single-line text field.
  2. Either enter all 50[1] state abbreviations, one per record, or find a columnar list of all 50, and copy-and-paste them into the field.
  3. Once you have 50 records, each with a different state abbreviation, right-click on the field name, select ‘customize field type,’ and change the field type from single-line text to single select.

That said, here’s a faster, easier way:

  1. Load this base
  2. In a different tab, open the base where you want a single-select {State} field.
  3. Add a new single-line text field to your base, calling it something like {State Select}.
  4. Return to the tab containing the base loaded in Step 1.
  5. Select the cell for {State Abbreviations} in Row 1.
  6. Press Ctrl-C to copy that cell.
  7. Return to the tab with your base and select the cell for {State Select} in Row 1.
  8. Press Ctrl-V to paste the value into that cell.

{State Select} for record 1 is set to 'AK'; the field type changes to single-select, with the 53[1] state options already configured.

You can now copy-and-paste your existing {State} column — assuming it has been normalized to use correct abbreviations only — into the {State Select} field to convert the data already entered to single-select format. (Note if {State} contains any invalid abbreviations or spelled-out state names, they will be added as additional options to your single-select — probably not what you want.)

  1. I ordinarily use 53 options, for all 50 states plus the District of Columbia (DC), Puerto Rico (PR), and US Virgin Islands (VI).