Keyword search for multiple words

Hello Everyone,

I'm trying to create a column and pull out keywords that match the "Text" from the input data.

Example:

Case	Text
K-283643	I cant complete this case due to incorrect dates.
K-836283	The case review has been complete with 3 fails.

the Keywords

Keywords

cant

incorrect

fails

I'm hoping to create an out put that does the following.

Case	Text	Keyword(s) Matched
K-283643	I cant complete this case due to incorrect dates.	cant, incorrect
K-836283	The case review has been complete with 3 fails.	Fails

Also if there is any possible way to highlight the keyword in the "Text" Column.

Thank you in advance for any help.

Accepted answers

@CRogers22
Just play around with the tools.

For your Text column: try the Text to Columns tool, and choose the option to split the words to separate rows. Then use a Join tool.

Chris

@CRogers22
one way of doing this
mark done if solved.

@CRogers22
Just play around with the tools.

Thank you all for the time!