Excel 表格可以反选数字?

2025-04-26 17:04:09
推荐回答(1个)
回答1:

=IF(ISERROR(FIND(0,A1)),"0","")&IF(ISERROR(FIND(1,A1)),1,"")&IF(ISERROR(FIND(2,A1)),2,"")&IF(ISERROR(FIND(3,A1)),3,"")&IF(ISERROR(FIND(4,A1)),4,"")&IF(ISERROR(FIND(5,A1)),5,"")&IF(ISERROR(FIND(6,A1)),6,"")&IF(ISERROR(FIND(7,A1)),7,"")&IF(ISERROR(FIND(8,A1)),8,"")&IF(ISERROR(FIND(9,A1)),9,"")