Hi everyone, this is my first post here!

I have an issue where I have a column with a state, city, some special characters, and maybe the spelled out version of the state all in one cell.

Examples:

Kansas City KS
Denver CO company name
Salt Lake City UT companyname
Southern Cal
Fairfield OH RET/SUPP CHN
St. Louis MO

My goal is to identify if there is anything named as a state, or a state abbreviation, (as close as I can get it).

I have a full spreadsheet of state names and state abbreviations to help me with the lookup, but I cannot figure out how use the "Find" function with a "Lookup" function to return me anything close to what I need.

It would be useful to figure out to find the two uppercase letters in the string, but I have googled and googled and cannot figure it out.

Any suggestions would be greatly appreciated.

Thank you!