如何将EXCEL单元格中用逗号隔开的文本 用公式复制到别的单元格里,并...答:用分列,以逗号为分隔符号更容易一些。假设数据在A列 在B1中输入或复制粘贴此公式 =MID($A1,FIND("#",SUBSTITUTE(","&$A1&",",",","#",COLUMN(A:A))),FIND("#",SUBSTITUTE(","&$A1&",",",","#",COLUMN(B:B)))-FIND("#",SUBSTITUTE(","&$A1&",",",","#",COLUMN(A:...