Hello.
I have a set of strings (="strings" column) and would to like to parse through them and search for specific terms (=the green cells). Then the formula should return all the terms it found in the string in comma delimted format (see "Expected Result" column)
EDIT: sample data for the screenshot was attached to this post
Untitled.jpg
I was working with IF, ISNUMBER and SEARCH functions, but so far did not reach my expected result.
Thank you for your help
fk_
Bookmarks