IN EXCEL, THE SAME COLUMN AND CONTENT ARE MERGED

The following is how to merge the contents of the two columns in Excel:Operation: Assemble a computer desktop.

Device system: Windows Win7.

Operating software: Microsoft Office Excel 2010.

1. First open Excel and select the cell.

2. Enter " " and click the cell on the left.

3. Then enter the " " symbol.

4. Then click the cell on the right.

5. Hit the enter key to see that the first line has been merged, then move the mouse to the lower right corner of the cell, and double-click the mouse when the cursor changes to the " " shape.

6. Finally, you can see that the data of the two columns have been merged.

1. First open Excel** and enter the relevant information into **.

2. After entering the data, click the data option on the navigation bar.

3. Then click Advanced Options in the Data column to enter.

4. Then select the list area and check the options shown in the icon and click OK.

5. Finally, the same column with the same content will be merged into one cell.

1. Punch in the excel document and position the mouse anywhere you want to merge the data.

2. Select "Classification Summary" in "Data".

3. Select "Count" in the pop-up window and click "OK".

4. Press CTRL+G at the same time to bring up the positioning window and select "Positioning Condition".

<>6. Start with"tab to select "Center after Merge" and you're good to go.

There are two ways to do this: first, assume that the document is as shown in the following figure, and you want to ab two columns to merge Method 1: Connect the first step with "&".

Enter the formula "=A1&B1" in cell C1, press Enter, cells A1 and B1 will be merged in C1, and then fill down (as shown in the figure) Step 2: Select the column (column C) just merged, right-click, and select "Copy" Step 3: Keep the column still selected, right-click again, and select "Paste Value" (that is, "123" icon, as shown in the figure) in "Paste Options" Step 4:

Delete columns A and B. Method 2: Use the phonetic function to enter "=phonetic(a1:" in c1

b1)" (as shown in the figure), press enter, fill down, and then repeat the second, third, and fourth steps in method 1. Note: phonetic is for continuous selections, and the cell content must be in text format!

Numbers don't work, and neither does converting numbers to text! You must change the area where you want to enter numbers to text format before you can use them.

1. Open Excel and enter the data you need to operate in.

2. Enter the formula =B1 in cell A5.

3. Click Enter to enter the data of B1 into A5.

4. Click cell A5 to pull down the operation, and you can enter the data of column B into column A.

5. Also enter the formula in A9: =C1.

6. Drop down the cell to enter the data of column C into column A.

7. Copy the cells entered from column B and column C, right-click and select "Paste as value".

8. Select column B and column C, right-click and select "Delete".

9. You can get the data that is merged into a column, and the following figure shows the display effect.

Excel is an office software, when we use the software to process data, we often need to merge the same content in **, let's take a look at how to merge the same content in the same column in Excel.