COMBINE MULTIPLE CELLS DATA IN ONE CELL IN EXCEL

COMBINE MULTIPLE CELLS DATA IN ONE CELL IN EXCEL

Some times we need to combine multiple cells data in one cell. There are various process to combine data of multiple cells but here I mention two type. 

 Process 1. 

A popular formula called "CONCATENATE" is used here.

Step 1. Select the cell where you want to combine the data.(Here - Cell D2)

Step 2. Type "=concatenate"

Step 3. Now select "A2" cell as text1 then type "," then select "B2" cell as text2

Step 4. If you have more than two cell then you continue with "," and selecting cell as text3,text4 etc.

But I have here only two cell. So I closed the bracket ")" and hit enter. Two cell is Combined. Now you can just drag and down for rest cells.

If you want to put a [space] between two cell then double click the first cell (D2) and change the formula as follows "  =CONCATENATE(A2,"[space]",B2)  " and hit enter. For rest just drag and down.

 Process 2. 

This process is so simple. Just use "&" and the multiple cell combined in one cell. So look the formula.

Step 1. Type "=" then select the cell A2 type "&" select the cell B2 [=A2&B2]

Step 2. Hit enter. Combined cell D2 is ready.

If you have multiple cell then continue with "&" and selecting cell [=A2&B2&C2&D2.....]

If you put [space],[special character] then double click the first cell (D2) and change the formula as follows "  =A2&"[space] "&B2 " and hit enter.For rest just drag and down.

Conclusion:- 

Here I show you how to combine multiple cell data in one cell. Two formulas are best as there own field. Use any of them as per your requirement. If this article helps you a little bit please shear it and thus support me. Thanks.