数据转换单元格问题

vspace

867805038197202，867805038196402，867805038194266，867805038204008，867805038193102，867805038204743，867805038199521，867805038200501，867805038196261，867805038203984，867805038195800，867805038196345，867805038197061，867805038196204，867805038197186，867805038196964，867805038196246，867805038193060，867805038194860，867805038199687，867805038200626，867805038199802，867805038197368，867805038196865，867805038192948，867805038196360，867805038196881，867805038194506，867805038204768，867805038193086，867805038199968，867805038197525，867805038204784，867805038197046，867805038199927，867805038200766，867805038196220，867805038194423，867805038203000，867805038196303，867805038199984，867805038199729，867805038202929，867805038193144，867805038200881，867805038199844，867805038193045，867805038199661，867805038193003，867805038196428，867805038201202，867805038199026，867805038193128，867805038200709，867805038200360，867805038199240，867805038200600，867805038199943，867805038200907，867805038200741，867805038198143，867805038199125，867805038196741，867805038192989，867805038198861，867805038193029，867805038193284，867805038199885，867805038200006，867805038203026	如何将A1的数据，转换成已,为间隔的单独单元格数据。见B列数据
	867805038197202
	867805038196402
	867805038194266
	867805038204008
	867805038193102
	867805038204743
	未完

xwcxks48

分列复制选择性粘贴转置

vspace

xwcxks48 发表于 2018-8-10 15:05
分列复制选择性粘贴转置

应该行不通吧

wofuocibei2008

SUBSTITUTE(INDEX(MID($A$1,ROW($A$1:$A$99)*16-15,16),ROW(A1)),"，","")向下拖

jiangxiaoyun

powerquery拆分为列

vspace

wofuocibei2008 发表于 2018-8-10 15:08
SUBSTITUTE(INDEX(MID($A$1,ROW($A$1:$A$99)*16-15,16),ROW(A1)),"，","")向下拖

有效。多谢兄台

xwcxks48

vspace 发表于 2018-8-10 15:08
应该行不通吧

可以的，见附件

ivanmetity

=SUBSTITUTE(MID($A$1,ROW(A1)*16-16+1,16),"，","")

vspace

xwcxks48 发表于 2018-8-10 15:15
可以的，见附件

这方法好，教教怎么分列操作的。

问山

LEFT(MID($A$1,ROW(A1)*16-15,16),15)