提取第二个"-" 與空格前的数据 (9845)

C2{=MID(B2,SMALL(IF(MID(B2,ROW($1:$98),1)="-",ROW($2:$99)),2),MAX((MID(B2,ROW($1:$98),1)=" ")*ROW($2:$99))-SMALL(IF(MID(B2,ROW($1:$98),1)="-",ROW($2:$99)),2))

另解=TRIM(MID(SUBSTITUTE(SUBSTITUTE(G2,"-"," ",2)," ",REPT(" ",99)),99,99))