extract a word from a cell containing multiple words and placing it in an adjacent cell

Put this formula in A2:

Formula:

=IF(ISNUMBER(SEARCH("secret",B2)),"Secret","")

then copy down.

Hope this helps.

Pete