Article directory
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 ▼
- Type in a blank cell
=
- After clicking the first cell you want to merge, enter
&
- After clicking the second cell you want to merge, press
Enter
enter - Fill lower cells merged by drop down
- (among them
B4
和C4
For 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.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "How to merge and delete columns in computer EXCEL?Table Data Quickly Delete Merged Cells", it will help you.
Welcome to share the link of this article:https://www.chenweiliang.com/cwl-29147.html
Welcome to the Telegram channel of Chen Weiliang's blog to get the latest updates!
📚 This guide contains huge value, 🌟This is a rare opportunity, don’t miss it! ⏰⌛💨
Share and like if you like!
Your sharing and likes are our continuous motivation!