求大神解题（在线等）

对于我这样的2B青年来说，我只能想到这个解法了，因为我不会数组公式
求高手简化公式：
=IF(ISERROR(FIND("0",B3)),"0","")&IF(ISERROR(FIND("1",B3)),"1","")&IF(ISERROR(FIND("2",B3)),"2","")&IF(ISERROR(FIND("3",B3)),"3","")&IF(ISERROR(FIND("4",B3)),"4","")&IF(ISERROR(FIND("5",B3)),"5","")&IF(ISERROR(FIND("6",B3)),"6","")&IF(ISERROR(FIND("7",B3)),"7","")&IF(ISERROR(FIND("8",B3)),"8","")&IF(ISERROR(FIND("9",B3)),"9","")
将b3替换成原数字所在的单元格。
已验证公式正确性

@zipall

@zzmxy

=IF(ISERR(FIND(0,A2)),0,"")&SUBSTITUTE(SUM(ISERR(FIND(ROW($1:$9),A2))*ROW($1:$9)*10^(9-ROW($1:$9))),0,)
數組公式