How to use the WPS table to quickly generate user names and passwords

a quick way to generate user names and passwords using the WPS table

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

2, Next, it is necessary to generate user name and password! Click D2, enter "=" Cnxx "&B2" (excluding the most foreign quotation marks) 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 the figure:

3, then use the same "&" 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 the figure:

4, a person with "&" will be the name code of each administrator and school name shorthand or school telephone number merge easy to complete the user name and password writing