How to extract the formula of birth date of ID card number

Recommended tutorial: Excel tutorial

Step 1: Open EXCEl file, select the column with the ID number, right-click, and select Copy

Step 2: Then select "Column" under the "Data" menu ”

Step 3: Select “Fixed Column Width” in the “Column Sorting” dialog box and click Next

Step 4: Click the ruler below the data preview and divide the ID number into 3 segments, with the middle segment being the date of birth. Click Next

Step 5: Click 1 and 3 marked in the icon, and select "Do not import this column (skip)" ”

Step 6: Select the middle column and select the “Date” format as the data format

##Step 7: Then click the small box after "Target Area"

Step 8: Select the desired area Fill in the date of birth area and press Enter

Step 9: Click Finish in the pop-up text column wizard

Step 10: The date of birth area selected in the interface will be automatically filled in

Extended information

Microsoft's OFFICE is the most popular office software, mainly available in two versions: OFFICE2010 and OFFICE2007. Office 2000 is a representative product of the third generation of office processing software. It can be used as an office and management platform to improve users' work efficiency and decision-making capabilities. There are 4 different versions of Office 2000 Chinese version: Standard Edition, Small and Medium Business Edition, Chinese Professional Edition and Enterprise Edition.

In Office 2000, each component still has a relatively clear division of labor: Generally speaking, Word is mainly used for text input, editing, typesetting, printing, etc.; Excel is mainly used for heavy calculation tasks. Budgeting, finance, data summary and other work; PowerPoint is mainly used to create presentations, slides and slides, etc.

Access is a desktop database system and database application; Outlook is a desktop information management application; FrontPage is mainly used to create and publish Internet Web pages.

Microsoft Office XP is the most important version of Office ever released by Microsoft, and is also considered to be the most powerful and easiest-to-use Office product to date.

The new version of Office abandons the previous convention of naming products after the year of product release! The XP in the product name is the abbreviation of English Experience, which means that the new version of Office will bring users a rich and fully expanded new experience after including Web services covering a wide range of devices.

In addition to the core Office XP programs—Microsoft Word, Excel, Outlook, and PowerPoint—Office XP Professional includes Microsoft Access 2002, the Office data.

To use Microsoft Office XP, the recommended system configuration is Microsoft Windows 2000 Professional, and the computer hardware configuration is a Pentium III processor and 128 MB of RAM.

The functions of WPSoffice of China Kingsoft Company are very similar to those of Microsoft Office. From 1989 to 1994, WPS has been the dominant office software in China. After Microsoft's Windows system quietly landed in China, the two formed two competing camps.

The above is the detailed content of How to extract the formula of birth date of ID card number. For more information, please follow other related articles on the PHP Chinese website!