Home > Topics > excel > body text

How to merge the contents of two columns into one column

藏色散人
Release: 2020-05-08 11:16:54
Original
14522 people have browsed it

How to merge the contents of two columns into one column

How to merge the contents of two columns into one column?

Open the corresponding excel form, as shown in the figure

Recommended: "Excel Tutorial"

How to merge the contents of two columns into one column

Suppose you want to merge the contents of the two columns with yellow shading as shown in the picture, and put them in the middle column

How to merge the contents of two columns into one column

Enter the formula in the first cell of the middle column "=A2&C2", A2 represents the location of the cell in the first column, and the location of the other cell of C2, as shown in the figure

How to merge the contents of two columns into one column

After clicking the enter key, you can find that the two The cell contents are merged, as shown in the figure

How to merge the contents of two columns into one column

Select the merged cells and pull down, you can find that the remaining cells have been merged, as shown in the figure

How to merge the contents of two columns into one column

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

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template