提取多个数字并用中文表示

kalako

如图，求教

良良

=TEXTJOIN("、",,TEXT(MID(SUBSTITUTE(A1," ",REPT(" ",50)),ROW(1:5)*50-49,50)/1,"[dbnum1]d"))

kalako

良良 发表于 2024-8-8 12:13
=TEXTJOIN("、",,TEXT(MID(SUBSTITUTE(A1," ",REPT(" ",50)),ROW(1:5)*50-49,50)/1,"[dbnum1]d"))

感谢！学习！

hxj119

=CONCAT(TEXT(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),ROW($1:$5)*99-98,99))/1,"[<30][DBNum1]d;[DBNum1]")&"、")

沈默00

=TEXTJOIN("、",,TEXT(TEXTSPLIT(A1," "),"[DBNUM1]D"))

kalako

良良 发表于 2024-8-8 12:13
=TEXTJOIN("、",,TEXT(MID(SUBSTITUTE(A1," ",REPT(" ",50)),ROW(1:5)*50-49,50)/1,"[dbnum1]d"))

请教，数字很多，最后提取不完整，该怎么修改公式呢？

kalako

沈默00 发表于 2024-8-8 13:40
=TEXTJOIN("、",,TEXT(TEXTSPLIT(A1," "),"[DBNUM1]D"))

我的版本没有TEXTSPLIT

jivy1212

1. =TEXTJOIN("、",1,TEXT(FILTERXML("<a><b>"&SUBSTITUTE(A1," ","</b><b>")&"</b></a>","a/b"),"[>31][dbnum1];[dbnum1]d"))

复制代码

良良

kalako 发表于 2024-8-8 13:40
请教，数字很多，最后提取不完整，该怎么修改公式呢？

=TEXTJOIN("、",,TEXT(MID(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),ROW(INDIRECT("1:"&LEN(A2)-LEN(SUBSTITUTE(A2," ",))+1))*LEN(A2)-LEN(A2)+1,LEN(A2))/1,"[>31][dbnum1];[dbnum1]d"))

无关岁月

1. =TEXTJOIN("、",,SUBSTITUTE(TEXT(IF(ISNUMBER(FIND(" "&ROW($1:$99)&" "," "&A1&" ")),ROW($1:$99),""),"[dbnum1]"),"一十","十"))

复制代码