怎样用公式将字段内的字母+数字与文本拆分？？

楷阳饶

我会选择快速填充，个别错误的手动修改

掷地有声

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

小小初哥哥

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

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

潇十一郎

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

木森人

奔跑的猪

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

吃喝玩乐收割机

=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))),"") 三键结束 右拉下拉

新兴宗

谢谢大家！！

寒度

=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))

姚栋乾

我会选择快速填充，个别错误的手动修改