WPS form user name and password generation tutorial

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

2, click D2, in the English half-width state input "=" cnxx "&b2", carriage return confirmed that a user name. "&" merges the name code with the company name here as a merge character

3, then use the same "&" to generate the password. Click E2, enter "=b2&" 84618316 "" in English half-width State, carriage return confirmation

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