IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER(FIND("com",A1))),"",A1)

来源：学生作业帮助网编辑：六六作业网时间：2024/11/21 20:49:45

IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER(FIND("com",A1))),"",A1)IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER

IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER(FIND("com",A1))),"",A1)
IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER(FIND("com",A1))),"",A1)

IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER(FIND("com",A1))),"",A1)
若A1中包含cn或com就把它清空