括號裡數據 分別提取 (11761)

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

區域數組 B2:D2 下拉{=TEXT({1,-1,0}%,SUBSTITUTE(SUBSTITUTE(MID(A2,FIND("(",A2)+1,99),")",),",",";"))*1

另解=INDEX(TEXT({1,-1,0}%,SUBSTITUTE(SUBSTITUTE(MID($A2,FIND("(",$A2)+1,99),")",),",",";")),COLUMN(A1))*1



留言