For a research I am currently conducting I extracted job descriptions/requirements from various vacancies on the web. These are extracted in an excel format with job descriptions and requirements of a specific vacancy in a different cell. I would like to extract specific words from the text (column A) into the next column (column B). For example, I want to extract the word 'engineering' of each job description into the next column (if it is job description course). I was wondering if this is possible with a 'simple' function or is it needed to use a macro..
Hope somebody can help me out!