当前位置:首页 > 随手记 > 正文内容

Excel中如何获取汉字拼音首字母

jiangbo4年前 (2020-09-25)随手记2738

提取汉字的拼音首字母的公式:

=LOOKUP(MID($C$2,COLUMN(A1),1),{"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"拉","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})

扫描二维码推送至手机访问。

版权声明:本文由jiangbo随手记发布,如需转载请注明出处。

本文链接:http://www.jiangbo.org.cn/post/125.html

分享给朋友:

发表评论

访客

◎欢迎参与讨论,请在这里发表您的看法和观点。