拆分 數據 (14715)

( 1 )B2:C5=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",99)),COLUMN(A1)*99-98,99))

( 2 )E2:E5=TEXT(-LOOKUP(1,-RIGHT(A2,ROW($1:$9))),"#,##0.00")

( Last )D2:D5=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,C2,E2),E2,REPT(" ",99)),99,99))