Just a quick little formula that checks to see if a cell contains specific text. This one checks to see if the cell contains the "@" sign, if it does then it puts an X in the cell if not then it will be left blank.
=IF(ISNUMBER(SEARCH("@",A2)),"X","")
No comments:
Post a Comment