Excel - Combine 2 columns of words, with one column of words in parantheses.

[Vanessa Maulden]

I need the two columns to be the product model and the manufacturer combined.  I have a column with the Manufacturer and a column with the Product Model.

Product Model must be entered in the format "Model (Manufacturer)"

examples....   XYZ 23 (Sony)............. Series 123 (Apple)

[#2]

You can use the Concatenate Function or the & Operator 

 like follows:

=B2&A2

=B2&" ("&A2&")"

=CONCATENATE(B2,A2)

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

Please see example file.

[#3]

Lenovo

M800

=H2&" ("&G2&")"

Thanks so much!!

This is what I have -- now what do I do to make the words appear there and in the rows below?

Vanessa

[#4]

If the formula is actually showing in the cell you need to change the cell format from TEXT to General and then confirm the formula again by putting the cursor in the cell and pressing enter.  If it's already a formula then you can just do the following.

You can use the autofill functionality as shown below:

[#5]

Thanks for our help!!

Vanessa

[#6]

Vanessa-

You're quite welcome.  Please feel free to post back to the community if you have any additional questions.  Always happy to help!

[#7]

Thanks Its real work@Matt Mickle