使用Excel串联功能 [英] Use Excel Concatenate function

问题描述

我正在尝试将三列中的数据合并到Excel中的一列中.例如，我想将Product，Location和Key_id合并为一列

I am trying to merge the data from three columns into one column in Excel. Example, i would like to merge Product, Location, and Key_id into one column

Product Location             Key_Id
Car           VA             86421910
Car           VA             86424482
Car           VA             86416836

Combined Column:
Car 'VA', '86421910'
Car 'VA', '86424482'
Car 'VA', '86416836'

我想知道Excel中是否有一种方法可以做到?提前致谢！过去，我在接受答案方面做得不好.我将尽我所能接受前进的答案.

I was wondering if there is a way in Excel that can do it? Thanks in advance! I was not doing a good job of accepting the answers in the past. I will do my part which is to accept the answer moving foward.

此致

推荐答案

http://www.info-stat.com/XLConCat.htm 显示了Excel中字符串连接的示例.如果我知道您使用的是哪个版本，并且可以识别列ID，那么我可以编写它.

http://www.info-stat.com/XLConCat.htm shows examples of string concatenation in Excel. If I knew which version you were using and could identify the column IDs I could write it.

假设产品为A列，位置为B列，Key_ID为第三列，数据从第2行开始

Assuming Product is Column A, Location is Column B and Key_ID is column three and data starts at row 2:

=A2&" '"&B2&"', '"&C2&"'"

这篇关于使用Excel串联功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！