How WPS quickly generates user names and passwords

In order to facilitate the memory, you can take the company abbreviation plus personal initials as the user name, with initials plus the company's phone number as the user's password. It sounds like trouble, but using the WPS Office 2013 form to do this task is very simple.

Detailed production steps are as follows:

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

Figure 1

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 Figure 2, 3

Figure 2

Figure 3

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 Figure 4

Figure 4

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!