WPS table tips for quickly generating user names and passwords

First, create a new workbook and enter the column headings and other information in the Sheet1. As shown in Figure 1

Figure 1

Next, it is necessary to generate the user name and password! Click D2, enter "=" Cnxx "&B2" (excluding the most outer Chinese quotes) in the English half-width state, and the carriage return confirms a username. "&" Here merges the name code with the company name as a merge character. And so on, the rest of the people's user names can be done this way. As shown in Figure 2 and 3:

Figure 2

Figure 3

The same is followed by "&" to generate the password. Click E2, enter "=b2&" 84618316 "" (excluding the most outer Chinese quotes) in the English Half-width State, carriage return confirmation. As shown in Figure 4

Figure 4

Xiao Li uses "&" to complete the user name and password by using the name code of each administrator and the school telephone number.