Hello All,

I'm looking to create an additional column in my table that lists the State Abbreviation if any are found in a string for Column A. If not I'd like the cell to say "CW" for country-wide (easy part of the formula.)

Not sure how to go about this. Possibly RegEx matching or VLOOKUP? Or something completely different? Preferably a formula for the cell that automatically does this for all my other files!

Here is one of the files I'm working with and a second one containing the State Abbreviations:

StateAbbExtract.txt
state-abbreviations.xls

Thanks and Cheers!
Jamie