I am dealing with some sales tax reports in which I base my calculations off the two letter state abbreviation. However, sometimes my report will spit out the full state name. Currently my column B is where my two letter state abbreviations and full state names appear. How do I tell Excel to convert the full state name into a two letter abbreviation? Do I need a new column? If so, can I make the state abbreviation copy over if it is correct? Would I need a reference table of all state names and abbreviations? I'm not sure if this is just formulas or a combo between formulas and vlookup. I'll upload an example file.
Solved by X. F. in 18 mins