雷宇 发表于 2021-11-12 21:11:00

一个单元格内有多个数值 如何整理成三位数格式

A1单元格内有数据0,1,2,9,15,34,107,654,...,999
恳请指教，如何整理成000,001,002,009,015,034,107,654,...999

顽强的小豆芽 发表于 2021-11-26 21:01:07

=textjoin(",",1,text(trim(mid(substitute(a1,",",rept(" ",99)),row(1:999)*99-98,99)),"000"))

崔筱伟 发表于 2021-12-31 05:42:33

=TEXTJOIN(",",,TEXT(FILTERXML("<a><b>"&SUBSTITUTE(A1,",","</b><b>")&"</b></a>","//b"),"000"))

财经小白 发表于 2021-12-31 15:58:54

=TEXTJOIN(",",1,IF(ISNUMBER(FIND(","&ROW($1:$999)&",",","&A2&",")),TEXT(ROW($1:$999),"000"),""))

品相一般 发表于 2022-1-18 07:47:13

感谢各位大佬鼎力帮助

良达 发表于 2022-1-27 16:13:53

=TEXTJOIN(",",,IF(ISERR(FIND(","&ROW(1:1000)-1&",",","&A1&",")),"",TEXT(ROW(1:1000)-1,"000")))
页: [1]
查看完整版本: 一个单元格内有多个数值 如何整理成三位数格式