Flexible use of Excel to break down the regular TXT text data

Just after the test, leadership whim, asked to count the proportion of men and women, average points, passing the number of information. Schools have been using proprietary software to register candidates ' data, but the software does not have these statistical functions, sweating. Fortunately, the software can be exported to the basic data as a text file, I think, get word or exce may have a solution. The following is the exported text, as shown in Figure 1.

Exported text

To count the data, the first thing to do is to separate the columns of data together, the first thought is to use Word text to form the function, but after trying to find that in Word to convert text to a table, you must have a text separator, but as shown in Figure 1, several columns of data are linked together, There is no symbolic separation that word can recognize, so blocked.

You can only try Excel again, finally found in the "Data" menu Excel "column" command, the following is the whole process of solving the problem.

1. Copy the text, perform "paste" in the A1 cell in the worksheet, and the data is automatically branch, as shown in Figure 2.

Automatic Branch

2. Select Column A, and on the Data menu, click the "Columns" command, as shown in Figure 3.

　　Computer Tutorial Breakdown command

3. In the Open Text Breakdown Wizard dialog box, select Fixed width based on the characteristics of the basic data. As shown in Figure 4.

Fixed width

4. Click Next to set the width of the field. Click to create a break line, hold down the left arrow to drag the position of the column, double-click to cancel the line. As shown in Figure 5.

Establish a breakdown line

5. After the breakdown, click Next to set the data type for each column. For example: the first column to be set to "text", otherwise, the test number of the front of the "0" will be shed; While the third column is set to General, Excel automatically determines and sets the data type by the contents of the cell. As shown in Figure 6.

Set the data type for each column

6. Click Finish. Blink time is completed, and then use the Excel filter, sorting and other functions to be able to count the required data. As shown in Figure 7.

Complete breakdown