1、先打开一个需要处理表格,我这里用的是excel2007,其他版本的大同小异
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1a20cf431adcbef2c734084a2af2edda2cc9fe8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中需要把一个单元格分成多个单元格的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b55b319ebc4b7459c2a9294c1fc1e178b8215f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选择工具栏内的“数据”选项卡。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7003af33a87e95075b4d6ee1e385343faf2b494?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击“分列”工具
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8773912b31bb05108b98aaa387adab44bede097?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、选择分割符号,然后点击下一步
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e9244750a7b342086e061c95f7b8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后根据自己的需要选择根据什么符号分割数据,由于单元格是用的是逗号,我这里就勾选的逗号,可以在下方看到分列以后的数据,如果是自己想要的就直接点击下一步。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7acb0a46f21fbe094d63e79665600c338744ad76?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、选择分列以后的数据类型,一般默认常规就行了,然后点击完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d6dfda919d090828381e30fd9c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、这个时候就看到原本在一个单元格的数据被分到了3个单元格里。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/adaf2edda3cc7cd9d1b70e5b3701213fb90e919d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)