Excel Problem: How do you save the contents of a non empty cell? See Question Supplement for details

Is this correct, please refer to:

1. Select this column of data first, click the menu bar data, divide the columns, and select a fixed width.

2. If there are multiple words in the cell, we will divide the text multiple times.

3. Enter a space in any cell and pull the drop-down box to the end.

4. After that, use the merged icon to merge the text and spaces.

5. Click the Enter key, the drop-down box is at the bottom of the data, and a space has been added in the middle of the data text of the whole column.

6. The last step is to paste the data in the cell as a value, and it is done.

Here's how:Tools Raw Materials: Dell i5, Win7,.

1. First select a blank cell, and then type: =b2&c2&d2.

2. Copy the cell after that.

3. In another blank cell, select "Paste as Numeric Value".

4. You can see the content after pasting.

5. Then select the cells that are being merged, and then click "Merge Cells".

6. Then click "OK" in the pop-up cell.

7. After the merging is completed, copy the contents of the cell.

8. Then paste it into the target cell.

9. Finally, you can see that all the data is saved to **.

<> because each non-null condition in the formula is pre-followed by a newline character. The solution can be changed to the Chenkai formula:

A2 formula: ="textjoin("

*Closed as, 1, b2:h2).

Yes, the formula can be a bit cumbersome and needs to be written with VBA, written later.

In excel, press alt +f11, view--**window, copy the following ** into it, f5 run:

It's best to test it out before using it.

sub hebing()

a = ""

for i = 1 to range("a65536").end(xlup).row + 1

if cells(i, 1) = "" then

range("c" & i + 1 & ":c" & range("a" & i + 1).end(xldown).row).merge

cells(range("a" & i - 1).end(xlup).row, 3) = a

a = ""

elseif a = "" then

a = cells(i, 1)

elsea = a & chr(10) &cells(i, 1)

end if

end if

nextend sub

If you want to use formulas, the first sentence of excel will remind you not to use merged cells as much as possible, because formulas can't handle it.

The specific steps are as follows:

The materials that need to be prepared are: computer, excel**.

1. First of all, open the required excel** and enter the page.

2. Then click the C10 cell to enter the formula: =A10&B10, press Enter to confirm.

3. Then click the C10 cell with left mouse button to drop down and fill in the cell below.

How to merge cells in excel how to keep all data in cells" The operation steps are:

1. Open the excel sheet;

2. If you merge A1:B6 cells, directly select "Merge Cells" in "Align", only the data in the upper left corner can be retained, and other values are discarded;

3. The traditional way of merging cells cannot keep all the data, so if you need to keep all the data to merge cells, you need to convert;

4. Select D1:E6 cells, and select "Merge Cells" in the "Merge" drop-down option of "Start" and "Alignment";

5. Select A1:B6 cell, press Ctrl+C, "Copy";

6. Double-click the merged cell d1:e6 to make it enter the state, then click the clipboard, and click the content just copied;

7. The copied data in the clipboard is pasted into the merged cell;

8. Press the Enter key to complete the operation, the cursor enters the next cell, and all the data of the A1:B6 cell is kept in the merged cell;

9. Delete the original a1:b6 or copy and paste d1:e6 into the a1:b6 area as needed.

Normally, when we merge cells, only keep the contents of the first cell, then, we want to keep all cell contents, how to merge cells?

Copy it to the bottom for later use. Then, enter the formula in the following cell and use & to connect the cells. Copy.

Then, merge the original cells and paste the alphabetically - values and numbers into your merged cells. As for the position, you can solve it with spaces and line breaks (alt + enter).

Suppose the contents of the two cells A1 and B1 are merged, and a space is inserted in the middle, and the result is written in the C1 cell, then the formula for C1 cell is as follows.

a1&" b1

Or. =concatenate(a1," b1)

No, you can only keep the contents of the first cell or use this method.

Enter "=a1&a2&a3" in a blank cell....After entering, the contents of the cells in the formula will be connected and displayed in one cell.

It's really not good, but you can set not to show grid lines, the effect is the same as if you merged cells, the main data is retained, and then the data that needs to be merged is selected and then draw a border on them

When excel merges cells, it generally only keeps the contents of the first cell, how do we want to keep the contents of all cells?