I have a huge amount of data that has no consistent sentence formatting, and I have a list of keywords I refer to. Whenever a keyword exists in the data, I want to extract them out onto another column. examples of how I want keywords to be extracted I don't mind if it gives "red apple" and "apple"

Currently I'm just using filters to find cells that has the same words, so I can key in extracted keywords as a batch/group