WPS table to sort students by name

The WPS table specifies that students are sorted by name as follows:

A list of students as pictured.

1, below we will extract the last word of the name. To use the function right () described previously, enter "=right (A 2, 1)" in the B2 cell. Then drag down to the mouse to fill, then each student's last word is extracted. As shown in Figure 6-1-13.

2. The next step is to sort by column B. Sort process slightly. After sorting, the interface is shown in Figure 6-1-14.

3, now can see the last word of the same students lined up together. Of course, when printing, delete column B.

Attach: Here is the main use of right () This function, its role is to find the specified content of the right character, here we are asking for the 1th character.