如何使EXCEL的中文名字快速变成简写的首个英文字母?答:,"R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}然后用公式 =LOOKUP(MID(A1,1,1),PinYin)&LOOKUP(MID(A1,2,1),PinYin)&LOOKUP(MID(A1,3,1),PinYin)&LOOKUP(MID(A1,4,1),PinYin)&LOOKUP(MID(A1,5,1),PinYin)【姓名最多N个字就用N-1个&】...
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",...