Home  >  Article  >  Topics  >  How to connect multiple columns end to end in Excel?

How to connect multiple columns end to end in Excel?

coldplay.xixi
coldplay.xixiOriginal
2020-06-22 14:48:5515445browse

How to connect multiple columns end to end in Excel?

Recommended tutorial: "excel basic tutorial"

How to connect multiple columns end to end in excel?

How to connect multiple columns end to end in Excel:

1. First copy the range with data in all columns:

How to connect multiple columns end to end in Excel?

2. Create a new word document and paste it in:

How to connect multiple columns end to end in Excel?

3. Click the "ten" symbol in the upper left corner of the pasted content, and the menu above will appear. "Table Tool":

How to connect multiple columns end to end in Excel?

4. Click "Table Tool" --- "Layout" --- "Data" --- "Convert to Text":

How to connect multiple columns end to end in Excel?

5. Click "Paragraph Mark" in the dialog box, and then "OK". The content will be merged into a column connected from beginning to end in word:

How to connect multiple columns end to end in Excel?

6. Copy it to excel and you’re done:

How to connect multiple columns end to end in Excel?

The above is the detailed content of How to connect multiple columns end to end in Excel?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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