I am looking for a formula in excel which will extract a part of a word in acell. For example : if cell A1 contains part of the word "construction", go tocell b1 and type "Construction" if not do nothing.