前三數字取出 (10502)

C3:E3 區域數組 {=TEXT({1,-1,0,"A"},SUBSTITUTE(SUBSTITUTE($B3,"=","*"),"*",";!"))

C4:E4=-LOOKUP(9,-MID(SUBSTITUTE($B3,"*",REPT(" ",99)),COLUMN(A1)*99-98,ROW($1:$99)))

C5:E5=TRIM(MID(SUBSTITUTE(SUBSTITUTE($B3,"=","*"),"*",REPT(" ",99)),COLUMN(A1)*99-98,99))