Try: =IF(ISERR(FIND("@gmail.com",A2,1)),"",A2) for your column B