excel 字符串拆分

我有一串数据是这样的,如下:

0000878702,0015579954,0015581832,0015582792,0015584265,0015661886,0015675467,0015678478,0020750954,0020848847,0022192574,0022677469,0022692265,0022713345,0022724525,0022839020,0024238583,0027223535,0027260617,0027260908,0027260992,0027261159,0027261178,0027261309,0027261675,0027261772,0029328771,0030607334,0031054769,0033329918,0033439119,0033560890,0033653636,0033857348,0033859467,0034228620,0034345788,0034726925,0041226852,0041229553,0041261914,0050021732,0050650544,0050994416,0050995598,0051235642,0051256685,0051257481,0051440818,0051602525,0051619300,0051637076,0051638292,0052324433,0053477630,0053963728,0054058270,0054086019,0054243401,0054539171,

需要对字符串进行分割,步骤如下:

第一步:

 

第二步:

 

第三步:

第四步:选取第一列,进行复制

第五步:

posted @ 2020-10-26 11:17  ctlaowang  阅读(1093)  评论(0编辑  收藏  举报