Here shows how to combine two individual cells of data into one cell. E.g. when first and last names are divided into 2 columns you enable to combine them into one column. In Excel, it is probable to combine, different cells of data into one cell. Follow steps given below to do it.

Instructions

Step 1

Start spreadsheet with cells that you yearning to merge. Then put in discourse adjacent to two columns that you desire to merge.

Step 2

Click first vacant cell beside first to cells that you like to merge.

Step 3

Click function (Fx) button.

Step 4

Function dialogue box will shows. In Function Category Section Choose "Text"

Step 5

In Function Name Section Choose "Concatenate"

Step 6

Concatenate dialogue box shows. Click small box with red arrow.

Step 7

Pick first cell that you desire to combine then click small box with red arrow.

Step 8

Press Tab key to get to "text2" filed. Enter comma or empty space based on how you are merged cells to show.

Step 9

Then click small box with red arrow. Press Tab key once more to obtain to "text3" sector. Choose next cell that you desire to merge. Then Click "OK"

Step 10

Now initially merged cell must be finish. To copy similar formula for remaining list you should utilize drag fill option. Choose finished cell move cursor over the small black square at bottom of cell. Click and drag mouse down.