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

%3CLINGO-SUB%20id%3D%22lingo-sub-197342%22%20slang%3D%22en-US%22%3EExcel%20-%20Combine%202%20columns%20of%20words%2C%20with%20one%20column%20of%20words%20in%20parantheses.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EI%20need%20the%20two%20columns%20to%20be%20the%20product%20model%20and%20the%20manufacturer%20combined.%20%26nbsp%3BI%20have%20a%20column%20with%20the%20Manufacturer%20and%20a%20column%20with%20the%20Product%20Model.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EProduct%20Model%20must%20be%20entered%20in%20the%20format%20%22%3CEM%3EModel%3C%2FEM%3E(%3CEM%3EManufacturer%3C%2FEM%3E)%22%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Eexamples....%26nbsp%3B%26nbsp%3B%20XYZ%2023%20(Sony).............%20Series%20123%20(Apple)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197467%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Combine%202%20columns%20of%20words%2C%20with%20one%20column%20of%20words%20in%20parantheses.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197467%22%20slang%3D%22en-US%22%3E%3CP%3EVanessa-%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou're%20quite%20welcome.%26nbsp%3B%20Please%20feel%20free%20to%20post%20back%20to%20the%20community%20if%20you%20have%20any%20additional%20questions.%26nbsp%3B%20Always%20happy%20to%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197453%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Combine%202%20columns%20of%20words%2C%20with%20one%20column%20of%20words%20in%20parantheses.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197453%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20our%20help!!%3C%2FP%3E%3CP%3EVanessa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197390%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Combine%202%20columns%20of%20words%2C%20with%20one%20column%20of%20words%20in%20parantheses.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197390%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20the%20formula%20is%20actually%20showing%20in%20the%20cell%20you%20need%20to%20change%20the%20cell%20format%20from%20TEXT%20to%20General%20and%20then%20confirm%20the%20formula%20again%20by%20putting%20the%20cursor%20in%20the%20cell%20and%20pressing%20enter.%26nbsp%3B%20If%20it's%20already%20a%20formula%20then%20you%20can%20just%20do%20the%20following.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20autofill%20functionality%20as%20shown%20below%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20521px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34812i688FBE8CDD0A5188%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Autofill.png%22%20title%3D%22Autofill.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197381%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Combine%202%20columns%20of%20words%2C%20with%20one%20column%20of%20words%20in%20parantheses.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197381%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3ELenovo%3C%2FTD%3E%3CTD%3EM800%3C%2FTD%3E%3CTD%3E%3DH2%26amp%3B%22%20(%22%26amp%3BG2%26amp%3B%22)%22%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EThanks%20so%20much!!%3C%2FP%3E%3CP%3EThis%20is%20what%26nbsp%3BI%20have%20--%20now%20what%20do%20I%20do%20to%20make%20the%20words%20appear%20there%20and%20in%20the%20rows%20below%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVanessa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197368%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Combine%202%20columns%20of%20words%2C%20with%20one%20column%20of%20words%20in%20parantheses.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197368%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20use%20the%20Concatenate%20Function%20or%20the%20%26amp%3B%20Operator%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3Blike%20follows%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DB2%26amp%3BA2%3C%2FP%3E%0A%3CP%3E%3DB2%26amp%3B%22%20(%22%26amp%3BA2%26amp%3B%22)%22%3C%2FP%3E%0A%3CP%3E%3DCONCATENATE(B2%2CA2)%3C%2FP%3E%0A%3CP%3E%3DCONCATENATE(B2%2C%22%20(%22%2CA2%2C%22)%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20941px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34807i8EE7702A71BA2370%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Concatenate.png%22%20title%3D%22Concatenate.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20see%20example%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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)

6 Replies

You can use the Concatenate Function or the & Operator 

 like follows:

 

=B2&A2

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

=CONCATENATE(B2,A2)

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

 

Concatenate.png

 

Please see example file.

 

 

LenovoM800=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

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:

 

Autofill.png

Vanessa-

 

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