A method of quickly generating user name and password with Jinshan WPS table

Many companies for each employee to provide a separate OA system account, in order to facilitate management, many of the administration will be in advance for employees to set up a different login username and password, however, if the number of employees, to set the user name and password, the workload is quite large. Today, small knitting on the following set of methods: company abbreviation plus personal initials as the user name, with initials plus the company's phone number as each user's password, for everyone to explain the rapid generation of user name and password Method!

Detailed production steps are as follows:

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 each administrator's name code and school names shorthand or school phone number merge easy to complete the user name and password writing, if you encounter similar situation, may wish to try this method!