Find word within a cell in Excel

To find a word or set of characters in an excel cell, the formula is below.

=IF(ISNUMBER(SEARCH("value",A1)),"Yes","No")

For example:

A query
=IF(ISNUMBER(SEARCH("AM",A2)),"Yes","No")

will give following result

If we want the value in the cell to be placed in the result column if it contains the characters, the formula can be tweaked as follows:

=IF(ISNUMBER(SEARCH("AM",A2)),A2,"")