C3=TRIM(LEFT(SUBSTITUTE(B3,"-",REPT(" ",99),SUMPRODUCT(N(MID(B3,ROW($1:$99),1)="-"))-2+1),99))
另解=LEFT(B3,FIND("-"&SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(B3,"-",REPT(" ",99)),198))," ","-"),B3)-1)
另解=LEFT(B3,LEN(B3)-LEN(TRIM(RIGHT(SUBSTITUTE(B3,"-",REPT(" ",99)),198)))-1)
另解=LOOKUP(1,-SEARCH("?-*-",MID(B3,ROW($1:$99),99)),LEFT(B3,ROW($1:$100)))
留言
張貼留言