Pulling key words from a column

[erinrog]

I'm looking for a function I can use to get the keyword (i.e. "Pipeline", "Star", "Wind 2", "Wrangler", "Ignition", etc.) for each project name within a list (see attached screenshot) in order to group them together by shared keywords. I've tried using the text to column function but haven't had success since the names don't all follow the same formatting conventions. Please let me know if anyone has any suggestions! 

[binuacs]

@erinrog have you tried using Find and Replace tool

[erinrog]

@binuacs Thank you for the suggestion! However, it's a pretty long list of project names- I just sent a small snippet as an example, so I think that would be too manual 

[binuacs]

@erinrog I am not following your exact requirement, based on my understanding if you have project names in a file, you can directly use that file for searching, if you think that doesn't solve your requirement can you explain a little bit more about your requirement,

[caltang]

The list you gave is basically the "Find in" list for a different data set correct? You are asking to find these items from a list... basically a dynamic find based on the list. You could do a macro to batch filter your entire dataset for keywords or you could just concatenate your entire list and put in a filter to use the expression:

[YourField] IN ("List here","List here 2","etc...")

[erinrog]

@binuacs So the only list I have is what I sent a screenshot of, I want to try to create a new column that somehow only pulls the key name for each of those longer project names seen in the original image but I don't actually have a list of what the key names are. Let me know if this clarifies!

[erinrog]

No, that list is the only data I have. What I'm trying to do is break those names down to be less specific so that I'll be able to group them later on by having the same project key word essentially. For example, in the snippet you'll see there's a project called "Project Harvest - VA FDD" and another called "Project Harvest - VA AC", I want to be able to use a unique filter later on & only have one of these pull through because they're essentially the same project despite the slightly different naming.