Hi Spencerb819,
Welcome to ExcelFox
Another point: In a Forum like this some of the people who help , like me, are not necessarily familiar with the various formats of the State/ Territory Abbreviations.
It might be quite easy to achieve what you want , I do not know because I do not have access to the relevant information. If I googled for a few hours I might find for example , a table listing all the state abbreviations.
To help get help , the thing would be to do the following:
Get some sample data together. ( Desensitize it, - make it up if you like ).
Restrict it to maybe about 40 rows. But try to pick data that tests as many typical scenarios as possible.
Give us a Before , and an After. The After should look just as you want a Formula or code to give you based on the data in the Before . Don't use a Image screenshot, other than to support the data you give us in another way. That other way is probably in this Forum through uploading a Workbook. ( You could also try the Tools indicated below in my signature, - they produce a screen shot in the Post which we can copy to a spreadsheet. )
And see if you can find a definitive list somewhere in the internet of all the List of U.S. state abbreviations.. .. the first thing I googled .. https://en.wikipedia.org/wiki/List_o..._abbreviations ... you could copy from .. but I expect you can find a better one if you look around...

On the face of it , it doesn't sound like it should be too difficult.

Alan