Current location - Quotes Website - Team slogan - How to extract the province, city, county and account nature of ID number in Excel?
How to extract the province, city, county and account nature of ID number in Excel?
First, you need to select the whole series of ID numbers.

After it is selected, click the data in the menu bar above.

Then find the "individual" item below and click.

Then select a fixed width in it, and then click Next.

Then click on the front and back of the province, city, county and household registration respectively, and click directly, and a bar will come out.

After the setting is completed, if there are no errors, click Next.

Then what you want to extract later is that between the characters you specify, you can get the nature of provinces, cities and counties and household registration.