數字分別取出 有正 負 小數點 (13731)

C2:F9{=IFERROR(LOOKUP(9^9,--MID($B2,SMALL(IF(ISNUMBER(-MID(SUBSTITUTE($B2,".",9),ROW($1:$29),1))*ISERR(-MID(SUBSTITUTE($B2,".",9)&"A",ROW($2:$30),1)),ROW($1:$29)),COLUMN(A1))-ROW($1:$9)+1,ROW($1:$9))),"")