之后的字符串公式
=MID(C1,FIND("*",SUBSTITUTE(C1,"/","*",(LEN(C1)-LEN(SUBSTITUTE(C1,"/","")))))+1,99)
之前的公式
=LEFT(C1,FIND("*",SUBSTITUTE(C1,"/","*",(LEN(C1)-LEN(SUBSTITUTE(C1,"/","")))))-1)
之后的字符串公式
=MID(C1,FIND("*",SUBSTITUTE(C1,"/","*",(LEN(C1)-LEN(SUBSTITUTE(C1,"/","")))))+1,99)
之前的公式
=LEFT(C1,FIND("*",SUBSTITUTE(C1,"/","*",(LEN(C1)-LEN(SUBSTITUTE(C1,"/","")))))-1)