Use the wps form to convert names to name codes

Just learned the Chen Xuaquan Teacher's tutorial (URL: Using WPS form to quickly generate username and password), the feeling of beauty is still unfinished. The premise of generating a password is the name code of the administrator, then, can you use WPS form batch get name code? The method is as follows:
1, after entering the basic information of the table, select A1 Cell, click on the "Formula" menu under the "name Steward" command, in the Definition Name dialog box that pops up, type "a" in the text box under the name in the current workbook option, and then enter the formula "={" under "Reference position" "," ";" Acridine "," A "; Viii. "," B ";" Cha "," C ";" 咑 "," D ";" 鵽 "," E ";" Hair "," F ";" 猤 "," G ";" Hafnium "," H ";" 夻 "," J "; Ka "," K ";" "", "L"; 嘸 "," M "; Temperature "," N ";" Oh "," O "; 妑 "," P ";" Seven "," Q "; 囕 "," R "; Sa "," S ";" He "," T "; 屲 "," W ";" Xi "," X ";" Ya "," Y ";" 帀 "," Z "}" (Figure 1), click OK to close the dialog box.

Figure 1
2. Select the B2 cell that holds the first admin name code, enter the formula "=if (a2=", "" ", VLOOKUP (a2,a,2) & VLOOKUP (Mid (a2,2,1), a,2) &vlookup (Mid (a2,3,1), a , 2)) "(as shown in Figure 2), you can get the first administrator's name code (Figure 3) after you hit enter.

Figure 2

Figure 3
3, select B2 cell, move the mouse to the lower right corner of the black fill handle double-click, you can complete the other formula fill, get all the administrator's name code (Figure 4).

Figure 4

How is the effect, please try.