第一步:打开需要拆分单元格内容的wps表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c9fcc3cec3fdfc035c7a3a28c63f8794a4c22624?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
第二步:选中要拆分的一列单元格,在菜单栏“数据”中选择“分列”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d53f8794a4c27d1e0624e25409d5ad6eddc43824?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
第三步:分列的方式有两种,分隔符和固定宽度,如果要拆分的一列单元格内容宽度一致就选择固定宽度,其余情况选择分隔符。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4cdea41cecfc451da81cb3e24?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
第四步:因为我们这个例子中有明显的分隔符“,”,所以我们选择“分隔符号”,单击“下一步”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8694a4c27d1ed21bdbcbf775bf6eddc451da3f24?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
第五步:在分隔符号“其他”中输入“,”,单击“下一步”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c2ae213ebb1cf41bd5ad6e3924?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
第六步:这一步不用选择,单击“完成”按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fd039245d688d43f56ab48626f1ed21b0ef43b24?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
如下图所示,整列单元格中的内容以“,”为分隔符分开。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2cec3fdfc03924519b7389f9594a4c27d1e2524?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述