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!

Mate, I think you will need business intelligence tool in that case LOL..... The forum guru above wrote down a list of companies before you can search them up from a text.


In your case, assuming you don't know any company names but you want to track it in the description, it's tough mate

@controlrex, I do have a list of company names which I can use to search for so the formula Tony Valko provided is quite helpful! Thank you!

The problem you described controlrex is something I have with job titles within the text since I do not have a list of different job titles that are used. It depends on what the company calls it... But according you there is a way to do this? I can imagine that's a tough job, is there a place on this forum were I can find more about this business intelligence tool? Just for looking, don't think I am able to use it

Well it's hard to explain about Text mining tool here. And High five for malaysians btw.