Search for Cells that contain Specific Words in Excel

Formula: =FIND("?",A1)>0
where ? is your word or chacter

Source: http://www.exceltip.com/st/Find_if_a_character_is_in_a_cell_in_Microsoft_Excel/393.html