How to merge two rows into one row in excel

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.

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"

## 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".

# 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)

#The content at this time is still a formula. We can select column C to copy and select "Value" as the paste option.

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.

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!