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中前一格中输姓名后一格中自动出现拼音码答:"K";"垃","L";"呒","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}点击“添加”,确定 现设你的姓名在A列如A2开始输入姓名,则在B2输入 =IF(A2="","",VLOOKUP(A2,a,2)&VLOOKUP(...