Quickly generate user names and passwords with the WPS Office table

Source: Internet
Author: User

The company wants to establish a brand-new personnel management information system. All people need to be added to the system as users in the early stages. Information department Xiao Li as the head of the project to give everyone to assign user name and password. In order to facilitate memory, Xiao Li decided to use the company abbreviation plus personal initials as everyone's username, with initials plus the company's telephone number as each user's password. Sounds like trouble, but Xiao Li uses wps Office 2012 form to complete this task is almost 10 fingers to pinch snail-extremely easy.

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

Figure 1

Next, it is necessary to generate the user name and password! Click D2, enter "=" Cnxx "&B2" (excluding the most outer Chinese quotes) 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

The same is followed by "&" 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

Xiao Li use "&" will each administrator's name code and school name 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!

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.