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

雷宇

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

顽强的小豆芽

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

崔筱伟

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

财经小白

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

品相一般

感谢各位大佬鼎力帮助

良达

=TEXTJOIN(",",,IF(ISERR(FIND(","&ROW(1:1000)-1&",",","&A1&",")),"",TEXT(ROW(1:1000)-1,"000")))