I'm trying to extract text from a cell at varying locations that matches up
with a list I have. I'm banking on the idea that somehow a function like
vlookup or something can be used simultaneously with it but allow me to
explain.

1. Skilled Excel User USA
2. England Master PPT User
3. Ultimate Denmark Word User

I want to extract the countries out of this list--USA, England, Denmark. Can
I set something up in a table where it will look up anything that matches the
table to extract this data? There are too many variations of countries and
inputted data format that I can't figure it out.