Excel from the 18-bit ID number in the interception of date of birth

2010-02-26  来源:本站原创  分类:Tech  人气:396 

Excel 18-bit ID number from the date of birth using the following formula in the interception,
= CONCATENATE ((LEFT (RIGHT (A2, 10), 2 )),-( LEFT (RIGHT (A2, 8), 2 )),-( LEFT (RIGHT (A2, 6), 2)))

The results are as follows ID
34 **** 19820820 **** 82-8-20
36 **** 19860926 **** 86-9-26
34 **** 19860504 **** 86-5-4
34 **** 19860528 **** 86-5-28
34 **** 19840805 **** 84-8-5
34 **** 19820418 **** 82-4-18
35 **** 19840415 **** 84-4-15
34 **** 19850126 **** 85-1-26
34 **** 19850126 **** 85-1-26
34 **** 19810228 **** 81-2-28
37 **** 19831015 **** 83-10-15

相关文章