Home > Topics > excel > body text

How to merge data in excel tables and add commas

藏色散人
Release: 2020-05-31 11:01:29
Original
17611 people have browsed it

How to merge data in excel tables and add commas

How to merge excel table data and add commas

Select the vertical column data in the excel table and copy;

Recommended: "Excel Tutorial"

How to merge data in excel tables and add commas

Paste the data into Word and select all (do not use shortcut keys);

How to merge data in excel tables and add commas

Select the layout toolbar, click Convert to Text, and press the OK button;

How to merge data in excel tables and add commas

Select all data and press Ctrl F , replace the paragraph symbol (^p) with a comma (,), click Replace All;

How to merge data in excel tables and add commas

Remove the unnecessary commas at the end;

How to merge data in excel tables and add commas

Copy the data to the Excel table and complete.

How to merge data in excel tables and add commas

The above is the detailed content of How to merge data in excel tables and add commas. 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