excel中,A列为姓名,要在B和C分别计入姓和名,怎么写函数公式?答:在ExcelK中要提取姓名的姓和名(不包含复姓的情况),如果姓名在A列并从A2开始,可以在B2、C2列分别输入:B2:=IF(LEN(A2)=2,RIGHT(A2,1),RIGHT(A2,2))C2:=IF(LEN(A2)=2,RIGHT(A2,1),RIGHT(A2,2))输入完成后双击向下快速填充。
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",...