Excel中一串数字,去除重复数字

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

比如:1230243,去重后,显示01234

(0)

相关推荐