单元格的值转成数组

文心雕龙凤

把单元格A1="220、316、318、320、406、408、402"的值变成数组
{220,316,318,320,406,408,402}

郑霖生

好办法不会，凑个热闹：都是3位
=--TRANSPOSE(MID(A1,ROW(INDIRECT("1:"&(LEN(A1)+1)/4))*4-3,3))

位数不确定
=--TRANSPOSE(MID(SUBSTITUTE(A1,"、",REPT(" ",99)),ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1,"、",""))+1))*99-98,99))

吃俺老孙一棒

大概这样子=transpose(trim(mid(substitute(a1,"、",rept(" ",99)),row(indirect("1:"&count(0/(mid(a1,row(1:99),1)="、")))*99-98,99))

刘世伟

=--MID(A1,COLUMN(INDIRECT("C1:C"&(LEN(A1)+1)/4,))*4-3,3)

她叫凡凡

=TRANSPOSE(FILTERXML("<a><b>"&SUBSTITUTE(A1,"、","</b><b>")&"</b></a>","//b"))

臧筱涛

=EVALUATE("{"&SUBSTITUTE($A$1,"、",";")&"}")
WPS偷个鸡。

用户难忘

C2=TRIM(MID(SUBSTITUTE(B2,"、",REPT(" ",99)),COLUMN(INDIRECT("C1:C"&LEN(B2)-LEN(SUBSTITUTE(B2,"、",))+1,))*99-98,99))*1

姜后仁者名

让微软搞个split函数吧