IFNA(IFS(ISNUMBER(FIND("(A)",A1)),"A",ISNUMBER(FIND("(B)",A1)),"B",ISNUMBER(FIND("(C)",A1)),"C",ISNUMBER(FIND("(D)",A1)),"D"),"没找到")
excel用公式进行多重查找替换
最新推荐文章于 2024-07-12 20:48:19 发布
IFNA(IFS(ISNUMBER(FIND("(A)",A1)),"A",ISNUMBER(FIND("(B)",A1)),"B",ISNUMBER(FIND("(C)",A1)),"C",ISNUMBER(FIND("(D)",A1)),"D"),"没找到")