How do you parse and merge data in Excel?

1, open the Excel software, and open the file to edit

2, we first look at the data disaggregation, as shown in the following figure: first select A1

3, after selecting A1, we found "data" in the menu bar, click to find "Breakdown"

4. Click "Breakdown" to open the "Text Breakdown Wizard" dialog box, click "Next" below the first dialog box.

5, then enter the second dialog box, note the following figure to fill in, select "Other" in the separator, and fill in the symbol "-", and then click "Next" Into the third dialog box, when we click "Finish", we can see that we completed the data of the breakdown

6, then we introduce how to merge the data, or take the data just for example, we selected C1 cell

7, enter the formula in cell C1 "=a1&"-"&b1" press ENTER to see the data merge successfully.