Skip to content

Instantly share code, notes, and snippets.

@bph

bph/switch-states-sheets.txt

Created February 24, 2021 00:04
Show Gist options
  • Save bph/0e4d600c1a42fecdd6c3d0077b4e2014 to your computer and use it in GitHub Desktop.
Save bph/0e4d600c1a42fecdd6c3d0077b4e2014 to your computer and use it in GitHub Desktop.
Download ZIP
Switch Statement for Google Sheets - Replace US Statenames with 2-Letter Acroynym.
Raw
switch-states-sheets.txt
=SWITCH(TRIM(AQ2), "Alabama","AL", "Alaska","AK","Arizona", "AZ", "Arkansas","AR","California", "CA","Colorado", "CO", "Connecticut","CT","Delaware","DE","Florida", "FL", "Georgia", "GA", "Hawaii","HI","Idaho","ID", "Illinois","IL","Indiana","IN","Iowa", "IA", "Kansas","KS", "Kentucky","KY","Louisiana", "LA","Maine","ME", "Maryland", "MD","Massachusetts","MA", "Michigan", "MI", "Minnesota", "MN", "Mississippi","MS","Missouri","MO","Montana","MT","Nebraska","NE", "Nevada","NV", "New Hampshire", "NH","New Jersey", "NJ", "New Mexico", "NM","New York", "NY", "North Carolina", "NC", "North Dakota","ND", "Ohio","OH", "Oklahoma","OK", "Oregon", "OR", "Pennsylvania","PA", "Rhode Island", "RI", "South Carolina","SC","South Dakota", "SD", "Tennessee", "TN","Texas", "TX", "Utah", "UT", "Vermont","VT","Virginia","VA", "Washington", "WA", "West Virginia","WV","Wisconsin","WI","Wyoming","WY",Trim(AQ2))
@bph
Copy link
Author

bph commented Feb 24, 2021

  • Before you use it, make sure to replace the cell AQ2 with the correct one for your Google sheet.
  • Paste it into the cell with the state name.
  • It trims the cell references of whitespace, so matching works.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment