How to merge and delete columns in Excel?Quickly delete merged cells from table data

If you enter a number in a cell (arithmetic sequence), it will appear as科学, but requires that it be displayed as a number.Then, divide the numbers into columns A and B, and merge them into column C, where "=A1&B1. "

I want to keep column C and delete column A and B, but if I delete column A or B arbitrarily, the data of column C will disappear, what should I do?

How to combine two columns into one table in Excel?

First, let's look at how EXCEL combines data,You can achieve merging by combining functions & ▼

Copy and paste them as "values"▼

• Then delete the cells before merging.

Computer EXCEL table data quickly delete merged cells

After merging in EXCEL, delete the cells before merging, but will keep the merged data.

The specific operation steps of this method are as follows:

1. Open the EXCEL table to be operated on the computer and use the merge function in the blank cell=B4&C4, then press Enter to complete function editing and input ▼

1. Type in a blank cell=
2. After clicking the first cell you want to merge, enter&
3. After clicking the second cell you want to merge, pressEnterenter
4. Fill lower cells merged by drop down

• (among themB4和C4For the cells to be merged, it can be changed according to the actual situation)

2. Then press Ctrl+C to copy the merged result cell▼

3. Right-click on a blank cell and select "Paste as Value" in "Paste Special" ▼

• Delete the cells before merging, and find that the cells before merging are deleted after the EXCEL table is merged, and the operation of retaining the merged data is completed.