有加减乘除符号数据分割到各栏位去

rayhen

D:F为最终成果

任何帮助，将不胜感激！

tchh666

1. =LET(A,TEXTJOIN("|",,A2:A5),B,TEXTSPLIT(A,ROW(1:10)-1,{",","|"},1),C,--TEXTSPLIT(A,B,"|"),HSTACK(TAKE(C,,1),B,TAKE(C,,-1)))

复制代码

365可用

rayhen

tchh666 发表于 2022-12-27 08:52
365可用

就是那意思,多谢老师了

袁勇

=LEFT(A2,LOOKUP(9^9,FIND({"*";"/";"+";"-"},A2))-1)

=LOOKUP(1,0/FIND({"*";"/";"+";"-"},A2),{"*";"/";"+";"-"})

=MID(A2,LOOKUP(9^9,FIND({"*";"/";"+";"-"},A2))+1,15)

云南陶肖民

=SUBSTITUTE(LEFT(A2,MAX(IF(ISNUMBER(FIND({"+","-","*","/"},A2)),FIND({"+","-","*","/"},A2),0))-1),",","")

=MID(A2,MAX(IF(ISNUMBER(FIND({"+","-","*","/"},A2)),FIND({"+","-","*","/"},A2),0)),1)

=MID(A2,MAX(IF(ISNUMBER(FIND({"+","-","*","/"},A2)),FIND({"+","-","*","/"},A2),0))+1,2)

hcm19522

D2=LOOKUP(9^9,LEFT(A2,ROW($1:$19))*1)

E2=LOOKUP(1,0/FIND({"+","-","*","/"},A2),{"+","-","*","/"})

F2=MID(A2,FIND(E2,A2)+1,9)

一式公式 D2:F5=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,LOOKUP(1,0/FIND({"+","-","*","/"},$A2),{"+","-","*","/"})," "&LOOKUP(1,0/FIND({"+","-","*","/"},$A2),{"+","-","*","/"})&" ")," ",REPT(" ",99)),COLUMN(A1)*99-98,99))

rayhen

老师们您们超级棒棒棒 , 感谢您们

jivy1212

1. =TEXT({1,-1,0}%,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"+",";+;"),"-",";-;"),"*",";!*;"),"/",";!/;"))

复制代码

老版