How to filter out more than 18 years old in a pile of ID cards?

A friend asked me a favor recently, let me in n multi-ID card to find people over 18 years of age. I also want to use SQL query to get, who let is dry it, did not expect to be my friend with Excel Instant solution .... How important it is to learn something new.

is actually taking advantage of the mid function in Excel. Example: Mid (x, Y, z) the mid function can intercept a character segment in a table, with three parameters, which in turn represent the number of cells to get, starting with the first few characters, and intercepting several. For example, mid (a1,7,4) is a string that intercepts the length from 7th to 4 in the A1 lattice. Said here, the above problem is solved. To be counted more than 18 years old, must be to obtain the identification number of the year, in the current year minus the obtained year, that is, age. For example, this year is 2016, then the function should be =2016-mid (a1,7,4). Note that the writing time is in English. Then drag the mouse to the lower right corner of the cell to drag and drop, all the age out ~ Right click, select Filter, by value brush selection, choose greater than or equal to 18 years old ~ Done!

is not quite simple. Although I said so much, just for the sake of detail. After all, for non-regular use of Excel students, it is really baffling.

How to filter out more than 18 years old in a pile of ID cards?