How to merge text in two columns of cells

How to merge text in two columns of cells: first open an excel table; then select a cell where you want to put the merged content, and enter the formula "=A1&B1()" in the cell; finally press Just press Enter.

The operating environment of this article: Windows7 system, Dell G3 computer, Microsoft Office Excel2007.

First open an excel table with two columns of text.

Select a cell where you want to place the merged content.

Enter the formula in this cell: =A1&B1 (or enter = and click the first cell, type the ampersand with the keyboard, and then click the second cell cells)

# After entering the formula, press the Enter key (Enter) to see the merged effect.

Place the cursor in the red circle, and when the cursor displays " ", pull it down.

As shown in the picture, the effect of pulling down at this time.

Pull to the last line to complete the merging of all text.

However, we see that the merged column is composed of formulas, and we need to turn the formulas into text. (Recommended: "Excel Tutorial")

Select the cells of the merged column of text.

# Right-click the mouse and select the "Paste Special" option in the pop-up menu.

In the pop-up dialog box, select "Value" and click the "OK" button.

The final effect is that all the formulas are turned into text and the operation is completed.

The above is the detailed content of How to merge text in two columns of cells. For more information, please follow other related articles on the PHP Chinese website!