Excel turns a column of data into a row and separates them with commas

Optionally select an empty cell, then it =textjoin(",",1,a2:a6), where a2:a6 is replaced by the column you want to merge.

If you want to merge the columns, it is a1, a2, a3 ....a10, then empty cell =textjoin(",",1,a1:a10)

It's easy to do with programming, assuming there are n rows, the data is in the first column, and the result is saved in A2.

private sub calc()

dim s as string ,i as integer,n as integer

for i=1 to n

if i=1 then s=cells(i,1)s=s & "，" & cells(i,1)next i

cells(1,2)=s

end sub

Copy into Word and paste directly.

Select all. On the menu bar, follow the following steps:

- Convert - Convert to text - OK.

And then. ctrl + h

Find content and select the special character below – paragraph markers.

Replace with a comma in . ok

1. Copy your data.

2. Enter word, paste selectively, and paste as unformatted text.

3. Find p to replace with'

Copy Paste Special, Transpose OK.

The original cell is still a cell after transposing, should it be separated by a comma?

The first inspection and replanting method: b1 = a1 & land skin","a2&",a3&"Another way is to save as CSV format, first use the transpose function to transpose the column content into rows, copy, paste selective-> transpose:

Delete the column content and save the file as a csv.

Open this CSV file with Windows' built-in notepad, and you will see that all the contents are separated by commas.

Copying these contents into the required cells in Excel is a good idea, but of course, this method is only suitable for changing everything to one cell. If you are needing a1:a5 to synthesize one, a6:

A10 to synthesize one. This is not the right way. There are only two ways to do this, and you need to use it according to the situation.

The first parameter is the type Zheng Nai Cong slag segmentation symbol, the second parameter true indicates that Bu Chun ignores the null value, and the following parameter is the area to be connected.

Select this column.

Click on the menu, and the data column is divided.

dialog box"Separator symbols"Next.

Tick"Comma"Are you sure.

In Excel, if a column of data is relatively standardized, and there are obvious segmentation conformities and segmentation rules, you can use the column method to turn the data into two columns and put them in Excel.

1. Select the entire column of data and click Data - Column.

2. Select the split symbol in the text splitting wizard and click Next.

3. At the division symbol, the system presets several options, according to the need, if the system is preset, you can click directly, if not, you can enter in others, in this example is the comma of the Chinese state, so enter the comma of the Chinese state in other columns, and click Next.

4. In the column format setting window, because the data in this example is a regular number, the format is regular by default, and you can click on it according to the actual situation. Click Finish directly, the column is successful, and the data is stored in two columns.

Put it in Notepad, save it as a TXT document, import external data with Excel, import wizard, select the separator, comma.

Copy the data into Excel first, which is a column, then the data-column, and select a comma for the separator.

This can be done with the Column command as follows:

1. Select the data area to be sorted;

2. Click "Data" and "Column" in the toolbar;

3. In the pop-up text column wizard setting window, check "Separate Symbol", next step;

4. In the pop-up text column wizard setting window, select comma for separator, next;

5. Column data format, select text, finish, and you can.

It's done in two steps:

1.You use the replace function first, and the value to be replaced is ", replaced with ",a".

2.Use the data column function, and use the separator symbol ",".

Data Columns Separator Commas.