Hello. Is there any way to quickly change state abbreviations (e.g. AK = Arkansas, AL= Alabama) in excel with a formula?
Hello. Is there any way to quickly change state abbreviations (e.g. AK = Arkansas, AL= Alabama) in excel with a formula?
TRY LIKE THIS
=INDEX({"Arkansas","Alabama"},MATCH(A1,{"AK","AL"},0))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
You could use Index/Match or Vlookup. I did both in this example.
****Disclaimer: I pulled the state/abbreviation list off the internet and did not verify its accuracy****
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks