How to merge two columns of data into one column in WPS How to merge two columns of data into one column in Excel

How to merge two columns of data into one column in WPS? When we use wps, we sometimes want to merge two columns of data into one column, so what is going on? Users can directly enter the = symbol in the blank cell, and then use the mouse to click on the two cells to be merged in order, and use the & connecting symbol to display the operation to complete the operation. Now let this site help users Let’s take a closer look at how Excel merges two columns of data into one column. How to merge two columns of data into one column in Excel 1. First, we need to enter the table page, as shown in the figure.

2. At this time, we directly enter the [=] symbol in the blank cell, and then use the mouse to click on the two cells to be merged, and use the & connection symbol in the middle to display it.

3. After pressing the Enter key, the two cells can be merged together to display, as shown in the picture.

4. Then, we use the left mouse button to pull down the [+] icon in the lower right corner of the cell to fill it. A dotted box will appear when filling.

5. When you release the mouse, you can merge the contents of other cells that need to be merged together, and the cell contents of the two columns will be displayed together, as shown in the figure.

The above is the detailed content of How to merge two columns of data into one column in WPS How to merge two columns of data into one column in Excel. For more information, please follow other related articles on the PHP Chinese website!