excel如何用函数自动填充名字的字母简写啊?紧急答:D2输入 =LOOKUP(CODE(C2),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",...
wps 或者excel 怎么用首字母查找姓名答:假设源数据(姓名)在Sheet1的A列。1、在Sheet1的B1输入 =LOOKUP(CODE(A1),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",...
excel 中怎么样把汉字转换成英文简称答:借用其他高手的回答:(以下公式为四个汉字内,再多还要加公式)=LOOKUP(CODE(A1),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",...