括號字符串 取出 (12683)

C2 右拉 下拉{=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT($B2,SMALL(IF(MID($B2,ROW($2:$199),1)=")",ROW($1:$198)),COLUMN(A1))),"(",REPT(" ",99)),99)),"")



留言