求1个excel公式:当A1输入0123456789任意一个或者几个数则B1显示0123456789中剩下的数字

列如:A1为0,B1就为123456789;A1为456,B1就为0123789
2024-11-22 00:49:45
推荐回答(2个)
回答1:

=IF(A1="","",IF(ISNUMBER(FIND(0,A1)),"",0)&SUBSTITUTE(SUMPRODUCT(ISERR(FIND(ROW($A$1:$A$9),A1))*ROW($A$1:$A$9)*10^(9-ROW($A$1:$A$9))),0,))

回答2:

B1公式:=SUBSTITUTE("0123456789",A1,"")