在excel中将三列数据合并为一列的方式如下:
1、假设需要合并的数据列为ABC三列,选择需要合并内容的单元格输入=A2&B2&C2,按ent键即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a600c338744ebf882cef0adcbf9d72a6159a7e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、使用concat函数合并,选择需要合并内容的单元格输入=concat,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8644ebf81a4c510f437b76887259252dd52aa5e1?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/500fd9f9d72a6059b8af75883a34349b023bbae1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
按ent键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6159252dd42a28349419a29949b5c9ea14cebfe1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
【加入社群一起学习】想要了解更多关于excel的相关信息,推荐咨询秒可职场。秒可职场将持续投入产品与课程内容的研发升级,积极拓展更多前沿职场课程,并开拓B端企业培训服务市场。“秒”代表“分秒、时刻”,“可”代表“可以、认可”,秒可致力于帮助广大职场人终身学习成长、获得认可和成就,实现共同富裕。