excel生成首写字母

绝地灬酷狼 2022-07-13 02:44 204阅读 0赞

生成A1列汉字的首写字母：

=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","P","Q","R","S","T","W","X","Y","Z"\})&IF(LEN(A1)>1,LOOKUP(CODE(MID(A1,2,1)),45217+\{-45185,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","Z"\}),"")&IF(LEN(A1)>2,LOOKUP(CODE(MID(A1,3,1)),45217+\{-45185,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","Z"\}),"")&IF(LEN(A1)>3,LOOKUP(CODE(MID(A1,4,1)),45217+\{-45185,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","Z"\}),"")

发表评论取消回复

表情：

评论列表（有 0 条评论，204人围观）

还没有评论，来说两句吧...

相关阅读

相关 Mysql -把字段首字母改成大写

先说一下项目背景。虽然说mysql字段大多数情况命名都是小写的。但我们是从Sqlserver迁移到Mysql所以就保留了Sqlserver的命名规则。但是又有个别表结构，命

╰+攻爆jí腚メ/ 2024年04月03日 14:13/ 0 赞/ 60 阅读

相关【杭电oj2026】首字母变大写

首字母变大写 Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Other

- 日理万妓/ 2022年09月25日 04:29/ 0 赞/ 165 阅读

相关 SDUTACM首字母变大写

题目描述输入一个英文句子，将每个单词的第一个字母改成大写字母。输入输入数据包含多个测试实例，每个测试实例是一个长度不超过100的英文句子，占一行。输出

柔情只为你懂/ 2022年09月22日 03:47/ 0 赞/ 174 阅读

相关获取汉字拼音首字母和五笔首字母

private void button1_Click(object sender, EventArgs e) {

╰半夏微凉°/ 2022年08月27日 03:26/ 0 赞/ 309 阅读

相关首字母变大写

首字母变大写 Time Limit: 1000ms Memory limit: 65536K 有疑问？点这里^\_^ 题目描述输入一个英文句子，将每个单词的

红太狼/ 2022年08月10日 04:55/ 0 赞/ 224 阅读

相关 excel生成首写字母

生成A1列汉字的首写字母： =LOOKUP(CODE(A1),45217+\{0,36,544,1101,1609,1793,2080,2560,2902,3845,4

绝地灬酷狼/ 2022年07月13日 02:44/ 0 赞/ 205 阅读

相关杭电 2026 首字母变大写

题目链接：[http://acm.hdu.edu.cn/showproblem.php?pid=2026][http_acm.hdu.edu.cn_showproblem.ph

素颜马尾好姑娘i/ 2022年05月18日 05:20/ 0 赞/ 180 阅读

相关【水】HDU2026首字母变大写

Time Limit: 2000/1000 MS (Java/Others) Memory Limit: 65536/32768 K (Java/Ot

心已赠人/ 2022年05月11日 09:24/ 0 赞/ 202 阅读

相关 Java生成汉字首字母(含多音字)

/ 汉字转换位汉语拼音首字母英文字符不变，特殊字符丢失支持多音字生成方式如（长沙市长:cssc,zssz,zssc,cs

Dear 丶/ 2021年12月12日 13:05/ 0 赞/ 569 阅读

相关后台对象传前台首字母变小写

今天做需求,一个简单的查询展示,结果展示的时候发现有几个字段的数据没有展示,如图所示

朱雀/ 2020年09月26日 11:13/ 0 赞/ 650 阅读