Two tips for merging cell contents in Excel

Tip One: Merge cell contents with hyphen "&"

If we want to combine the contents of multiple columns into a column without using a function, a small hyphen "&" will be able to fix it. For example, to merge columns A, B, and c into column D, do the following:

1, only need to enter the formula in the cell D1: =A1&B1&C1;

2, again select D1 cell, move the mouse, when the mouse shape becomes a black solid cross (that is, you copy the formula to the cell below column D by using the fill handle), and then drag down the left mouse button so that the contents of columns A, B, and C are merged into the corresponding cells in column D.

3, select D column, perform a copy operation, and then select the D column again, perform the edit → paste selective command, open the Paste Selective dialog box, select the value option, press the OK button, and the contents of column D are the result of the merge, not the formula.

Also, if you want to add spaces or dashes (-) between the merged text, type & "" & Or &-"&."　　The first step needs to be changed to =a1& "-" &B1& "-" &c1. Tutorial

Tip Two: Using the CONCATENATE function

The CONCATENATE function merges the text of multiple cells into a single cell, as in the previous example:

1, in the D1 cell input formula: =concatenate (A1,B1,C1) can;

Then in accordance with the 2nd, 3 steps in turn operation can!

Here if you want to underline (-), you can enter this way: =concatenate (a1,& "&,B1,&"-"&,C1")

Learning tips: Complete the 1th, 2 steps, the merge effect has been achieved, but at this point if you delete a, B, c column, the formula will appear an error. Therefore, the 3rd step is required to convert the formula to the invariant "value". It's very simple, just go and try it.