Extract words from big text in excel cell

Hi there,

I like to extract different company names from a cell which contains a large amount of text. I already know how to extract one specific sentence or word from the text. However, in this case I have a list of over a hundred possible company names that can occur in the text. I would like excel to check the large amount of text in column A for all the different company names I have in the list and if the formula (or macro?) finds a match extract the company name in column B. I'm not sure if I need a macro for this or if it can be done with a formula.

I hope somebody can help me with this!