excel生成首写字母
来源:互联网 发布:域名购买哪家网站靠谱 编辑:程序博客网 时间:2024/06/05 07:56
生成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"}),"")
- excel生成首写字母
- Excel列序号生成字母表示
- HDU_2026 首写字母变大写
- hduoj 2026 首写字母变大写
- Excel应用-自动生成字母序列号(ABCDE...AA...XFD)
- PHP 实现数字转字母,生成Excel列标
- word2007自动生成目录小写字母变大写
- word自动生成目录--小写字母变大写
- 生成随即密码(数字加大写或者消协字母)
- 自已写的excel报表生成
- 把首写字母大写,其他的字母小写
- 汉字首写字母获取算法
- mysql 中文首写字母排序
- 中文转化成拼音首写字母
- java 获取文字首写字母
- Java生成和操作Excel文件(读、写)
- hdu_2026_字母变大写
- 随机生成数字字母
- Linux报“xxx is not in the sudoers file.This incident will be reported” 错误解决方法
- 10.5 Swift类方法
- C语言实现二叉排序树的增删查操作
- 使用Freeline提高你的工作效率
- 10.6 Swift中subscripts基本语法
- excel生成首写字母
- JavaScript对象声明
- MT6580 使用外部PA出现无声、音量小或者无法调增益
- 配置NTP时间服务器
- Vmware给ubuntu添加新硬盘(转)
- 工具1--rundeck
- -bash: screen: command not found解决
- TOMCAT配置HTTPS和SSL并HTTP请求强转为HTTPS请求
- Android studio 2.2.3分享项目到github教程(纯自己的方法,非Copy)