Combine 2 cell into one

K

Kyle

Is there a way to combine 2 cells data into one. I have 2
columns that I need to combine together. One Column is P/N
& Other is description.

Ex. Col A Col B
110123 3" nut

Need to make two column data into one
 
K

Ken Wright

With your data in A1 and B1, in C1 put =A1&B1 and copy down. Or, if you want a space in there,
then do =A1&" "&B1 and copy down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to combine wordings in two columns 3
Combing 2 lists of data 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Combining Letters and Numbers 1
combining column contents ? 4
Combine Multiple Worksheets 2
Combine rows and Qty 1
Excel Concatenate with line breaks but ignore blank cells 3

Top