How to capture text in a text string using excel formula - MrExcel.com

Hi guys, hope you can help me about a simple formula of extracting text in a text string.. I have a list of words to find in cel A2 to A6 and i want.

www.mrexcel.com