Pulling key words from a column

Question

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!

Screenshot 2025-03-06 140230.png

erinrog · Answer

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.

erinrog · Answer

@binu_acs 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!

caltang · Answer

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...")