拆運算式成三格 (10917)

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

另解 D2=LEFT(A2,MIN(FIND({"+","-","*","/"},A2&"+-*/"))-1)*1

另解 E2=LOOKUP(1,0/LEFT(A2,ROW($1:$19)),MID(A2,ROW($2:$20),1))