WPS表格数据拆分求解

xiaoniuniuaa

如何将一个单元格中的一组数据分别拆分在多个单元格中？

博爱风雨同舟

=TRIM(MID(SUBSTITUTE($A$2&CHAR(10)&$A$3,CHAR(10),REPT(" ",99)),ROW(A1)*100-99,99))

xlllw203

1. =TRIM(MID(SUBSTITUTE(A$2&A$3,",",REPT(" ",99)),ROW(A1)*99-98,99))

复制代码

下拉
如果想留逗号，在公式上加 &"," 就可以

无聊的黑猫

=TRIM(MID(SUBSTITUTE(INDEX($A$2:$A$7,SMALL(IF(LEN($A$2:$A$7)-LEN(SUBSTITUTE($A$2:$A$7,",",""))>=COLUMN($A:$K),ROW($1:$6)),ROW(A1))),",",","&REPT(" ",99)),TRIM(MID(TEXTJOIN(REPT(" ",99),1,IF(LEN($A$2:$A$7)-LEN(SUBSTITUTE($A$2:$A$7,",",""))>=COLUMN($A:$K),COLUMN($A:$K),"")),ROW(A1)*99-98,99))*1*99-98,99))三键

sucx007

=EVALUATE("{"""&SUBSTITUTE(A2&CHAR(10)&A3,CHAR(10),""";""")&"""}")[code][/code]

祝洪忠-

复制内容  
桌面右键 新建 记事本  粘贴

然后复制记事本中的内容，粘贴到WPS表格里

橒♂蝣

=TRIM(MID(SUBSTITUTE(A3,CHAR(10),REPT(" ",99)),ROW(A2)*99-98,99))