How to merge the contents of two columns into one column

How to merge the contents of two columns into one column?

Open the corresponding excel form, as shown in the figure

Recommended: "Excel Tutorial"

Suppose you want to merge the contents of the two columns with yellow shading as shown in the picture, and put them in the middle column

Enter the formula in the first cell of the middle column "=A2&C2", A2 represents the location of the cell in the first column, and the location of the other cell of C2, as shown in the figure

After clicking the enter key, you can find that the two The cell contents are merged, as shown in the figure

Select the merged cells and pull down, you can find that the remaining cells have been merged, as shown in the figure

The above is the detailed content of How to merge the contents of two columns into one column. For more information, please follow other related articles on the PHP Chinese website!