Use Excel Concatenate function

Question

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'

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.

Regards,

Bart Kiers · Accepted Answer · 2010-12-22 20:08:55Z

3

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.

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

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

edited Dec 22, 2010 at 20:08

Bart Kiers

171k38 gold badges307 silver badges297 bronze badges

answered Dec 22, 2010 at 20:05

Demitrius Nelon

1,2681 gold badge11 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Costis Aivalis · Accepted Answer · 2010-12-22 20:25:41Z

1

=CONCATENATE(A2," '",B2,"', '",C2,"'")

edited Dec 22, 2010 at 20:25

answered Dec 22, 2010 at 20:09

Costis Aivalis

13.8k3 gold badges49 silver badges48 bronze badges

Collectives™ on Stack Overflow

Use Excel Concatenate function

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related