I have a column that has job listings with extra info, so I only want to grab the job position and place it into a new cell.
A1: Seeking Assistant to the marketing division...
B1: Assistant
(keyword list): Analyst, Assistant, Associate, Coordinator... etc.
Is there a formula or script that creates B1 based on a keyword found in A1 while checking the keyword list?