Good morning everyone,

I would really appreciate if somebody could give me a hand with this:
I'm trying to extract the state for each one of my cells on the row
labeled "Description", the data looks like this:

DESCRIPTION
Abbeville, LA Micropolitan Statistical Area
Aberdeen, SD Micropolitan Statistical Area
Aberdeen, WA Micropolitan Statistical Area
Abilene, TX Metropolitan Statistical Area
Ada, OK Micropolitan Statistical Area
Adrian, MI Micropolitan Statistical Area
Akron, OH Metropolitan Statistical Area
Alamogordo, NM Micropolitan Statistical Area
Albany, GA Metropolitan Statistical Area
Albany-Lebanon, OR Micropolitan Statistical Area
Albany-Schenectady-Troy, NY Metropolitan Statistical Area

Thank you!

JM