前後數字 提取 有負號 (12152)

B2=TEXT(LOOKUP(1,0/LEFT(A2,ROW($1:$9)),LEFT(A2,ROW($1:$9))*1),"0.000")

C2=IF(ISERR(FIND("--",A2)),"","-")&TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",9)),9))

一式公式B2:C8=INDEX(TEXT({1,-1}%%,REPLACE($A2,FIND("-",$A2,2),1,";")),COLUMN(A1))

另解B2=TEXT(IMREAL(A2&"j"),"0.000")

另解C2=TEXT(-IMAGINARY(A2&"j"),"0.000")