Home  >  Article  >  How to merge text in two columns of cells

How to merge text in two columns of cells

藏色散人
藏色散人Original
2021-02-07 14:22:1077793browse

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.

How to merge text in two columns of cells

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

First open an excel table with two columns of text.

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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)

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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

How to merge text in two columns of cells

Select the cells of the merged column of text.

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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

How to merge text in two columns of cells

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn