强制送往精神病院 发表于 2021-10-4 12:56:00

字符串提取连接的问题

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

张陈镒 发表于 2021-10-16 07:53:26

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

以乱为主 发表于 2021-11-4 16:09:59

如果上面那个不能用试试下面这个=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)),"(",""),")","")))

黄鲲 发表于 2021-11-12 01:11:27

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

步步高昇 发表于 2021-11-20 04:03:59

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

诗和远方离我很远 发表于 2021-12-22 11:20:37

concat同样是2019版函数

岚岚自语话清风 发表于 2022-1-2 15:49:12

嗯，所以我下面发了另一个比较绕的让他试试
页: [1]
查看完整版本: 字符串提取连接的问题