如何将excel一个单元格里的数按条件拆分多个单元格

kristing215

如何将excel一个单元格里的数按条件拆分多个单元格，具体见附件

满坛皆为吾师

右拉下拉
=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1&"、","(6",")、6"),")、",REPT(" ",666)),(ROW(A1)*2+COLUMN(A1)-2)*666-665,666))

Michael.Deng

C3=MID($A$1,IFERROR(FIND("&",SUBSTITUTE($A$1,"、","&",ROW(A1))),"0")+1,FIND("&",SUBSTITUTE($A$1,"(6","&",ROW(A2)))-IFERROR(FIND("&",SUBSTITUTE($A$1,"、","&",ROW(A1))),"0")-1)
然后往下拉、再往上拉

D2=MID($A$1,FIND("&",SUBSTITUTE($A$1,"(6","&",ROW(A1)))+1,IFERROR(FIND("&",SUBSTITUTE($A$1,"、","&",ROW(A1))),"269")-FIND("&",SUBSTITUTE($A$1,"(6","&",ROW(A1)))-2)

hcm19522

(先)F2:F19{=TEXT(MAX(IFERROR(MID(TRIM(MID(SUBSTITUTE($A$1,"、",REPT(" ",299)),ROW(B1)*299-298,299)),ROW($1:$19),8)*1,)),"0;;")

(後)E2:E19=SUBSTITUTE(TRIM(MID(SUBSTITUTE($A$1,"、",REPT(" ",299)),ROW(A1)*299-298,299)),"("&F2&")",)