EXCEL如何将一个表格中的一串文字分开
1、第一先在工作表中打开所需要文字分列的表格。https://iknow-pic.cdn.bcebos.com/fc1f4134970a304ea8e98eb1dfc8a786c8175cb5?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg2、接着框选所需分列的单元格，点击菜单栏中的数据选项卡，选择分列按钮。https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fa576e3aec57ee3d6d55fbda0a?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg3、接着再在弹出的分列向导中，选择分隔符号，再点下一步。https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d16996ab32afddeb48f8d5464cf?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg4、紧接着在分列向导第二步中，根据需要选择分隔符号，点下一步。https://iknow-pic.cdn.bcebos.com/b999a9014c086e06e83b16000c087bf40bd1cbee?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg5、最后，选择分列的数据格式，默认选常规。https://iknow-pic.cdn.bcebos.com/6c224f4a20a44623183d8c299622720e0df3d781?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg6、点击确定。这就是分列后的效果。https://iknow-pic.cdn.bcebos.com/a08b87d6277f9e2feb0b35431130e924b899f3bb?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg
页:
[1]