office-skills

excel身份证提取出生年月日
将函数=MID(B2,7,8)输入如图所在位置,回车或是点击任一单元格,即自动提取出出生日期。B2为身份证号的坐标,7为从第7位数字提了起,8为提取8个连续数字。如只想提取出年月,可以输入=MID(B2,7,6)

excel 身份证 年龄


身份证 excel 提取性别

win7 excel 多窗口独立显示//////不相互覆盖---EN
下载这个小工具MicrosoftEasyFix**** //////box-软件安装

合并多个excel---多薄多表合并 search in this blog

excel 页眉页脚 一共几页第几页 设置
“页面布局”—>“打印标题”—“页眉/页脚”---自定义页眉等等




Comments

Popular posts from this blog

The differences of business model among the voice of China, I am a singer and Sing my song.

The Voice of China 2016, Season 5. The top singers and the final champion winner---who?

will china become the next superpower leader of the world?