Switch Statement for Google Sheets - Replace US Statenames with 2-Letter Acroynym.

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))

• 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.