Some useful Excel Formulas which may or may not be useful to people Save's time Googling around for Excel formulas Cell contains specific text Search Excel cell for specific text and return yes if found. =IF(ISNUMBER(SEARCH(":",C2)), "Yes", "No") External Source