1, insert two empty columns after column D (E, F), and then enter the formula in cell D1: =b1&c1&d1.
2, select D1 cell again, use "fill handle" to copy the above formula to the cell below D column, the contents of B, C and D are merged into the corresponding cell of e column.
3, select the column e, perform a copy operation, then select the F column, perform the edit-paste Selective command, open the Paste Selective dialog box, select the value option, press the OK button, and the contents of the E column (not the formula) are copied to column F.
4, the B, C, D, e column Delete, complete the merger work.
Tip: Complete the 1th, 2 steps, the merge effect has been implemented, but if you delete the B, C, D columns, the formula will appear an error. Therefore, the 3rd step is required to convert the formula to the invariant "value".