How to use the essential toolbox in excel to extract the date of birth or gender from the ID number? Some friends may not know it yet, so today I will bring you the essential toolbox in excel to extract the date of birth from the ID number. Or gender methods, you can come and take a look.
First, download and install the necessary excel toolbox on your computer. After installation, open your EXCEL file, and there will be an additional function named "Toolbox" on the toolbar. Below, the editor will take Class 1 of **Primary School to demonstrate to you:
Click on the toolbox, find the search function column, and click on the search function. Then look for a column and enter "Extract information". Click Search, then select the "Extract information from ID card" function bar in the matching function name, and click Execute.
Current function selection: Extract information from ID card, formulate data source selection: ID card to be extracted, formulate target cell: select the location that appears after extraction, and then select the extraction type, gender, age, and date of birth.
Click OK.
Finally, select all the cells in the lower right corner and "double-click" to fill them in. That's it.
The above is the method of extracting the date of birth or gender from the ID number in the Excel essential toolbox brought by the editor. I hope it can help everyone.
