B3:E9{=REPLACE(B2,-LOOKUP(1,-LARGE((MID(B2,ROW($1:$49),1)="-")*ROW($1:$49),{1,2}))+1,LEN(TRIM(LEFT(RIGHT(SUBSTITUTE(B2,"-",REPT(" ",49)),98),49))),TEXT(LEFT(RIGHT(SUBSTITUTE(B2,"-",REPT(" ",49)),98),49)+1,REPT(0,LEN(TRIM(LEFT(RIGHT(SUBSTITUTE(B2,"-",REPT(" ",49)),98),49))))))
留言
張貼留言