Question

How do we merge two or more cells in one ?​

Answer 1

Explanation:

Select the cell where you want to put the combined data.

Type = and select the first cell you want to combine.

Type & and use quotation marks with a space enclosed.

Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.

Answer 2

Answer:

Here is how to use it:

Select the cells that you want to merge.

Press Control + 1 to open the format cells dialogue box.

In the Alignment tab, in the Horizontal drop-down, select Center Across Selection.

Click OK.

This would merge the cells in a way that whatever you enter in the leftmost cell gets centered, however, you can still select each cell individually. This also does not show an error when you try and sort the data.

NOTE: For Center to Across to work, make sure only the leftmost cell has data.

.

.

.

.

HOPE IT HELPS...................

Please mark me as brainliest