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"

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

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

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

Remove the unnecessary commas at the end;

Copy the data to the Excel table and complete.

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!