Quickly generate user name and password with WPS form

According to the requirements of provincial departments, primary and secondary schools need to activate educational equipment management Information system. All personnel involved in equipment management should be added to the system as users in the early stage. Xiao Li as a school administrator, to give everyone to assign user name and password. For the convenience of everyone, Xiao Li decided to use the school abbreviation plus personal name Total six or seven characters of the first letter as everyone's username, with personal name plus school phone number as each user's password. Using the WPS OFFICE 2012 form to accomplish this task is almost 10 fingers--extremely easy.

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

Second, the generation of user names and passwords two columns.

1, click D2, in the English half-width state input "=" Cnxx "&B2" (excluding the most external Chinese quotes), carriage return confirmation.

2, click E2, in the English half-width state input "=b2&" 84618316 "" (excluding the most external Chinese quotes), carriage return confirmation.

3, the use of automatic filling of other personnel to complete the user name and password entry.

Highlights of the period: use "&" to combine characters. This example uses "&" to combine the name codes of each administrator with the school name or the school phone number.