字符串提取连接的问题

强制送往精神病院

想把字符串中的数字字符提取出来放在不同的单元格里,我用的是office2010,没有textjoin等等的函数,想问不用这些高版本的函数,用office2010函数怎么来解决这个问题

测试2 - 副本.rar (12.13 KB, 下载次数: 204)

2021-10-4 12:56 上传

点击文件名下载附件
测试2 - 副本.rar

张陈镒

=CONCAT(TEXT(MID(TRIM(MID(SUBSTITUTE($C$1,"→",REPT(" ",99)),ROW(1:1)*99-98,99)),ROW($1:$99),1),"0;0;0;")) 三键结束

以乱为主

如果上面那个不能用试试下面这个=MIDB(SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE($C$1,"→",REPT(" ",99)),ROW(1:1)*99-98,99)),"(",""),")",""),SEARCHB("?",SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE($C$1,"→",REPT(" ",99)),ROW(1:1)*99-98,99)),"(",""),")","")),LEN(SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE($C$1,"→",REPT(" ",99)),ROW(1:1)*99-98,99)),"(",""),")",""))*2-LENB(SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE($C$1,"→",REPT(" ",99)),ROW(1:1)*99-98,99)),"(",""),")","")))

黄鲲

第一个手输入
C14
=MID(C$1,2+FIND("&",SUBSTITUTE(C$1,"→","&",ROW(A1))),5)

步步高昇

=RIGHT(SMALL(IFERROR(ROW($1:$99)/1%%%+MID(SUBSTITUTE(C$1," ",),ROW($1:$99),5),""),ROW(A1)),5)
数组三键下拉。

诗和远方离我很远

concat同样是2019版函数

岚岚自语话清风

嗯，所以我下面发了另一个比较绕的让他试试