How do I make a list of worksheets in Excel2013?
1. Select the next column that we want to split, switch to the Start tab, and then execute the Insert Sheet Column command in the Insert group in the Cells group. This is the preparation for splitting the column, of course, if you need to split the columns have enough blank columns to fill the content you need to split out, there is no need to do this step. We'll split it into two columns, just one more blank column.
Excel2013
2, select the column we need to split, note that the content to be separated by a fixed symbol, easy to distinguish between, we use the short line separated, and then switch to the Data tab, click the Data Tools group in the "Columns" button.
Excel2013
3, will pop up the text Breakdown Wizard-1th step, a total of 3 steps dialog box, we click the Next button.
4, in the jump to the Text Column Wizard-Step 2nd, in a total of 3 steps dialog box, we select the symbol for our separate content in the separator area, select the other item, and then enter a dash in the text box that follows, and then click the Next button.
Excel2013
5. In the "Text Breakdown Wizard-3rd step, 3 Steps" dialog box, we simply click the "Finish" button.
Excel2013
6, return to the worksheet, you can see the effect of the disaggregation.