Easy extraction of Identity card province information with Excel add-in

In the establishment of Enterprise employees Excel form process, the employee ID number, the province, the gender and other information are required to enter. If the unit staff is numerous, the related personal information input workload is undoubtedly quite big. So, can we make the tedious personal information input process easier to improve our productivity? The answer is certainly yes. Because we just need to take advantage of an Excel add-in , we can easily achieve this.

Download Excel add-in "to ask for provinces and cities according to ID card", then unzip the downloaded RAR format with the same name to any location on your hard disk (such as the "C: Add-ins" directory), run "Excel 2007" (similar to other versions of the operation), and click the Round button in the upper-left corner, select Excel Options , open the Add-ins branch of the Excel Options dialog box; then click the Go button under the branch to open the Add-Ins dialog box (Figure 1), and then check the new "Find Provinces by id" checkbox at a and click OK.

After the above steps, we completed the Excel add-in "according to the ID card for provinces and cities." XLA "Add in Excel 2007, and then open a" Employee information table for an organization that has entered the name information. xlsx Workbook (Figure 2), Then in the A2 cell in Figure 2, enter the function "=SFZ (B2," DQ ")" (excluding the most external quotes, the same below), after the carriage return to drag the fill handle to complete all employees "province" household registration information of the rapid entry operation, this time you can see the effect, such as a place. Of course, and so on, enter "=SFZ (B2," in cell B2). SR ")", enter "=SFZ (B2," XB ") in cell C2, and drag the fill handle down to quickly complete the quick entry of information such as" Birth date "and" gender ", such as B, C two.