If cell contains specific text, return that text

How would I pull only a specific word from a text cell? If you see my example, in one column I have various job titles. If A2 contains "Manager", then in B2 return "Manager. If A1 contains "Coordinator", return "Coordinator. Etc.

Excel Forum.jpg

How many different words are you looking for?

Make a list of the keywords you're looking for, in say E1:E5 for example.

Then use this to find those keywords in the string in A1
=IFERROR(LOOKUP(2^15,SEARCH(E$1:E$5,A1),E$1:E$5),"no keywords found")


Note, there CANNOT be any blanks in your list of keywords in E1:E5

Perfect! Thank you!

You're welcome.

A couple other notes about that formula.
It's NOT case senstive, change Search to Find if you want it to be case sensitive.
If there are 2 or more of the keywords found in the string, it returns the one that is listed last (furthest down) in the list E1:E5