The use of auxiliary columns to get the target data, and then the data in the copy to the B column can be. Specific operation please refer to the following steps, the demonstration software version for excel2007.

1, first of all, on the computer to create a new excel file, and then enter the target data, as shown in the figure.

2, and then use the C column as an auxiliary column, in cell C1 enter the command "= A1 & B1".

3, and then select the C1 form of the cross icon that appears in the lower right corner, pull down, so that the remaining forms to perform the same command.

4, and then the contents of the C column to perform the copy operation, as shown in the figure.

5, and then just copied the contents of the paste to the B column, as shown.

6, and then set the paste option to "only the value" to be displayed normally, and finally delete the contents of column C can be. After completing the above settings, you can complete the requirements of the topic.