1. 通过函数公式分行
=MID($A$1,FIND("\",SUBSTITUTE(";"&$A$1&";",";","\",ROW(1:1))),FIND("\",SUBSTITUTE(";"&$A$1&";",";","\",ROW(2:2)))-FIND("\",SUBSTITUTE(";"&$A$1&";",";","\",ROW(1:1)))-1)
效果:
2. 构建内存数据实现分列
定义名称"a",在【引用位置】编辑框中输入以下公式:
=EVALUATE("{"""&SUBSTITUTE(Sheet1!$A1,",",""",""")&"""}")
选中B1单元格,然后输入以下公式:
=INDEX(a,COLUMN(A:A))
然后拖吧......
效果: