Uses Excel to separate 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