Shulou(Shulou.com)06/02 Report--

This article will explain in detail how to merge the text of two columns of cells in excel. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

Merging two columns of cell text method: first open an excel table; then select a cell to put the contents of the merger, and enter the formula "=A1&B1()" in the cell; finally press Enter key.

First open an excel sheet with two columns of text.

Select a cell in which you want to place the merged contents.

Enter the formula: = A1 & B1 in this cell (or enter =, click the first cell, type & on keyboard, click the second cell)

After entering the formula, press Enter to see the combined effect.

Place the cursor in the red circle, and when the cursor shows "+," pull down.

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

Drag to the last line to complete the merge of all text.

However, we see that the merged column is composed of formulas, and we still need to translate the formulas into words.（）

Select the cells of the merged column.

Right-click and select Paste Selective from the pop-up menu.

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

The final result was that all the formulas had become words, and the operation was complete.

About "excel how to merge the text of two columns of cells" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.