Sorry, I dont know how I cant figure this out. I need to get only the two digit state abbreviation from City, ST Zip. Need to make sure if the city has more than one name it pulls the state correctly. Thank you.
Here are a few examples:
1) PHILADELPHIA, PA 19111
2) Salt Lake City, UT 84108
3) Magnolia, NJ 08094
The Result I need from each:
1) PA
2) UT
3) NJ
Here are a few examples:
1) PHILADELPHIA, PA 19111
2) Salt Lake City, UT 84108
3) Magnolia, NJ 08094
The Result I need from each:
1) PA
2) UT
3) NJ