整攔符號隔開 取出成一欄 (13842)

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

I2:I12{=IFERROR(TRIM(MID(SUBSTITUTE(INDEX(H:H,SMALL(IF(LEN(H$2:H$5)-LEN(SUBSTITUTE(H$2:H$5,"/",))+1>=COLUMN(A:I),ROW($2:$5)),ROW(A1))),"/",REPT(" ",99)),RIGHT(SMALL(IF(LEN(H$2:H$5)-LEN(SUBSTITUTE(H$2:H$5,"/",))+1>=COLUMN(A:I),ROW($2:$5)/1%+COLUMN(A:I)),ROW(A1)))*99-98,99)),"")