wps表格教程:三秒钟获取字词对应的第一个字母
时间:2022-02-09 13:53:22
点击下载:能获取字词前一、二、三个汉字音序的模板:获取汉字音序的模板.et
预览该模板:
在日常工作过程中,我们常需要获取汉字对应的第一个字母,比如,学生用音序查字法查字词典,医院建立药品查询系统,KTV建立歌曲查询系统……有没有办法轻松获取字词的第一个字母呢?大家都知道ET和EXCLE可以按音序排列中文数据,这就表明电子表格已经能洞悉汉字拼音的第一个字母与其在汉字编码系统的位置的关系了。只要查询出汉字在编码系统中的位置,并告知相同音序的汉字在编码中的起始位置,电子表格就可以将汉字的音序轻松获取。
想三秒钟获取汉字对应的第一个字母就打开你的WPS表格2012,跟我试试吧!
一、打开原始工作簿,在准备填充字母的列粘贴下列嵌套公式:
=LOOKUP(CODE(A2),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"})
在这个公式中,CODE函数旨在查询词语(字符串)第一个字符对应的数字代码,这些代码其实标明了这个汉字在代码库中的具体排位,LOOKP函数就根据不同音序汉字在代码库中的起始位置,获取到这个汉字的第一个字母了。
其中,A2是引用汉语字词所在的单元格名称,大家可获取字词前两个汉字所对应的第一个字母根据实际情况修改。
二、如果你想获取词语第二个汉字对应的字母,可以将上述公式中的A2改为MID(A2,2,1),表示从字符串的第二个开始取的第一个,即第二个。具体公式为:
=LOOKUP(CODE(MID(A2,2,1)),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"})
如果想取第三个可以以此类推,即:
=LOOKUP(CODE(MID(A2,3,1)),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"})
三、如果想获取前两个汉字音序怎么办?用“&”将获取第一、二个汉字音序的公式合并即可。如果想获取前三个汉字音序就用“&”将获取第一、二、三个汉字音序的公式合并。
获取字符串前三个汉字音序的公式:
=LOOKUP(CODE(A2),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"})&LOOKUP(CODE(MID(A2,2,1)),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"})&LOOKUP(CODE(MID(A2,3,1)),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"})
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
怎样将同一篇WPS文档设置多种页面版式
![](https://img.aspxhome.com/file/2023/7/53567_0s.jpg)
Word2013如何插入专业公式
![](https://img.aspxhome.com/file/2023/7/20587_0s.jpg)
怎样在Excel中自动突出纯汉字的单元格
![](https://img.aspxhome.com/file/2023/6/37736_0s.png)
Excel2013第一次打开都出现“ 向程序发送命令时出现问题”的解决方法
excel如何调换行列位置?excel快速换行列位置方法
![](https://img.aspxhome.com/file/2023/5/39775_0s.jpg)
office 2016官网下载地址 office2016破解版下载
![](https://img.aspxhome.com/file/2023/0/15650_0s.png)
如何使用Word制作生成二维码 Word生成二维码实例教程
![](https://img.aspxhome.com/file/2023/4/33394_0s.png)
excel中画圆圈的方法图解步骤
电脑ip地址设置为多少?电脑ip地址设置教程
![](https://img.aspxhome.com/file/2023/4/47984_0s.png)
win10系统开机后一直停留在启动页面转圈怎么办?
![](https://img.aspxhome.com/file/2023/2/46742_0s.png)
word中插入页码和修改页码格式的方法
![](https://img.aspxhome.com/file/2023/0/33090_0s.jpg)
excel横向打印的自动排版
![](https://img.aspxhome.com/file/2023/3/41673_0s.jpg)
Excel表格中mod函数的使用方法有哪些
excel表格怎么制作3D柱状图表?
![](https://img.aspxhome.com/file/2023/9/a141579_0s.jpg)
用替换法删除Word2007中的空行
![](https://img.aspxhome.com/file/2023/7/21217_0s.jpg)
在word中怎样设置空心字
excel怎么加批注
![](https://img.aspxhome.com/file/2023/5/37185_0s.png)
用Word制作日历的方法
excel利用函数求平均值的方法
Win10蓝屏终止代码dpc怎么办?Win10蓝屏终止代码dpc解决方法
![](https://img.aspxhome.com/file/2023/3/51843_0s.jpg)