![How to merge two rows into one row in excel](https://img.php.cn/upload/article/000/000/020/5e40b5585dbfa295.jpg)
How to merge two excel rows into one row
Open the excel file you need to process, for example, I need What is column A and column B merged.
![1581298852374866.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/875/208/678/1581298852374866.png)
Select the first row of column C (C1), enter the "=" sign, and then click on the first cell A1 of the column to be merged, then you can see C1 The content in C1 is automatically "=A1"
![1581298858404696.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/252/376/719/1581298858404696.png)
## and then enter the "&" symbol (I like to call it the ampersand). At this time, C1 is "=A1&".
Then click the first cell B1 in the second column that needs to be merged. At this time, C1 is "=A1&B1".
![1581298865861051.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/742/269/582/1581298865861051.png)
# Type Enter and we will find that the content of C1 has become the merged content of A1 and B1.
Then we use Excel to pull, and all the contents of column C are the combined contents of columns A and B.
(The method of pulling is to place the cursor in the lower right corner of cell C1. When the cursor changes to a solid black plus sign, click the left mouse button to pull down)
![1581298874553576.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/530/554/714/1581298874553576.png)
![1581298881382898.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/385/337/762/1581298881382898.png)
#The content at this time is still a formula. We can select column C to copy and select "Value" as the paste option.
![1581298888704096.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/400/423/847/1581298888704096.png)
![1581298893649984.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/914/147/263/1581298893649984.png)
![1581298898151732.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/465/750/984/1581298898151732.png)
If you need to add a certain character to the merged content, the formula can be entered as = A1&"Haha"&B1, just enter the characters you need in double quotes.
![1581298904677775.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/135/724/396/1581298904677775.png)
![1581298909747645.png How to merge two rows into one row in excel](https://img.php.cn/upload/image/136/915/925/1581298909747645.png)
For more Excel-related technical articles, please visit the
Excel Basic Tutorial column!
The above is the detailed content of How to merge two rows into one row in excel. For more information, please follow other related articles on the PHP Chinese website!