有你没烦脑 发表于 2022-1-1 08:24:00

=LEFT(A1,MATCH(,0/(MID(SUBSTITUTE(A1," ","好"),ROW($1:$99),1)>"吖"),)-1)
数组
D1:
=SUBSTITUTE(A1,C1,)

章春泽 发表于 2022-1-3 19:34:02

B1:=LEFT(A1,FIND(" ",CONCAT(MIDB(A1,ROW($1:$99),1)))-1)

C1:=TRIM(SUBSTITUTE(A1,B1,))

火锅烧烤吃不够啤酒得管够 发表于 2022-1-4 09:19:26

非数组
=LEFT($A1,MATCH(1,FREQUENCY(2,LENB(MID(SUBSTITUTE($A1," ","我"),ROW($1:$20),1))),)-1)
=TRIM(SUBSTITUTE(A1,B1,))

天理难容 发表于 2022-1-11 16:35:58

胡小相青青 发表于 2022-1-18 18:16:08

B1=IF(LEN(A1)>20,VLOOKUP("* ",LEFTB($A1,ROW($1:$99)+{1,0}),2,),SUBSTITUTE($A1,A1,))右拉下拉

启明星光 发表于 2022-1-26 08:10:42

=IFERROR(IFERROR(IF(FIND(" ",$A1),TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",99)),COLUMN(A1)*99-98,99)),""),TRIM(MID(SUBSTITUTE(REPLACE($A1,SMALL(IFERROR(0/(MID($A1,ROW($1:$99),1)>"Z")*ROW($1:$99)*1+ROW($1:$99),""),1),0," ")," ",REPT(" ",99)),COLUMN(A1)*99-98,99))),"") 三键结束 右拉下拉

挥之不去的思念 发表于 2022-2-4 04:22:03

谢谢大家！！

月光恋曲 发表于 2022-2-4 16:14:23

=TRIM(MID(REPLACE($A1,MATCH(,0/(MMULT(--ISNUMBER(--MID($A1,ROW($1:$20)+{0,1},1)),{1;2})=1))+1,,REPT(" ",50)),COLUMN(A$1)*50-49,50))
页: 1 2 [3]
查看完整版本: 怎样用公式将字段内的字母+数字与文本拆分？？