筛选提取包含数字部分
=IF(ISNUMBER(FIND("0", A2)) + ISNUMBER(FIND("1", A2)) + ISNUMBER(FIND("2", A2)) + ISNUMBER(FIND("3", A2)) + ISNUMBER(FIND("4", A2)) + ISNUMBER(FIND("5", A2)) + ISNUMBER(FIND("6", A2)) + ISNUMBER(FIND("7", A2)) + ISNUMBER(FIND("8", A2)) + ISNUMBER(FIND("9", A2)) > 0, A2, "")
筛选提取包含小写部分
=IF(ISNUMBER(FIND("a", A2)) + ISNUMBER(FIND("b", A2)) + ISNUMBER(FIND("c", A2)) + ISNUMBER(FIND("d", A2)) + ISNUMBER(FIND("e", A2)) + ISNUMBER(FIND("f", A2)) + ISNUMBER(FIND("g", A2)) + ISNUMBER(FIND("h", A2)) + ISNUMBER(FIND("i", A2)) + ISNUMBER(FIND("j", A2)) + ISNUMBER(FIND("k", A2)) + ISNUMBER(FIND("l", A2)) + ISNUMBER(FIND("m", A2)) + ISNUMBER(FIND("n", A2)) + ISNUMBER(FIND("o", A2)) + ISNUMBER(FIND("p", A2)) + ISNUMBER(FIND("q", A2)) + ISNUMBER(FIND("r", A2)) + ISNUMBER(FIND("s", A2)) + ISNUMBER(FIND("t", A2)) + ISNUMBER(FIND("u", A2)) + ISNUMBER(FIND("v", A2)) + ISNUMBER(FIND("w", A2)) + ISNUMBER(FIND("x", A2)) + ISNUMBER(FIND("y", A2)) + ISNUMBER(FIND("z", A2)) > 0, A2, "")
根据C\D两列是否为空，为空则使用B列进行填充
=IF(AND(LEN(C2)=0,LEN(D2)=0),B2,"")
