excel表格里的姓名和身证号提取姓名拼音首字母+出生年月日答:公式为:=LOOKUP(CODE(B2),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y",...
如果在Excel用函数实现对拼音的首字母提取?答:=MID(a1,1,1)&MID(a1,6,1)&MID(a1,11,1)不算空格是这样的 算空格在退后一位 告诉你个可实现的方法吧 你先把拼音分列 以空格为分列条件 然后再用mid函数提取分出来的每个拼音的首字母 用&和并 比如分成a1 wang b1 xiao c1 gang 在d1内打上=MID(a1,1,1)&MID(b1,1,1)&MID(c1,1,...