用公式：
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("0123456789",LEFT(A1),""),MID(A1,2,1),""),MID(A1,3,1),""),RIGHT(A1),"")
=IF(ISNUMBER(FIND("0",A2)),"","0")&IF(ISNUMBER(FIND("1",A2)),"","1")&IF(ISNUMBER(FIND("2",A2)),"","2")&IF(ISNUMBER(FIND("3",A2)),"","3")&IF(ISNUMBER(FIND("4",A2)),"","4")&IF(ISNUMBER(FIND("5",A2)),"","5")&IF(ISNUMBER(FIND("6",A2)),"","6")&IF(ISNUMBER(FIND("7",A2)),"","7")&IF(ISNUMBER(FIND("8",A2)),"","8")&IF(ISNUMBER(FIND("9",A2)),"","9")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024