在excel中如何将汉字转化为拼音（Excel如何把汉字转换为拼音首字母）

导读今天给大家分享一下提取汉字拼音首字母的方法，比如把“黄蓉”转换为“HR”。下图，为方法一完整操作动图1、1.如下图，是某萌妹子要提取汉字拼音首字母的文件，现....

今天给大家分享一下提取汉字拼音首字母的方法，比如把“黄蓉”转换为“HR”。下图，为方法一完整操作动图

1、

1.如下图，是某萌妹子要提取汉字拼音首字母的文件，现在我们一次帮她转换吧！

2.点击DIY工具箱（一款Excel插件，百度方方格子进入官网即可下载安装）

3.点击拼音笔画，汉字转拼音

4.在区域选中项输入A2:A9（即汉字单元格区域），勾选拼音首字母。点击确定

5.选择首字母存放单元格位置B2，然后点击确定即可完成

2、定义名称 函数法

1.点击公式，点击定义名称

2.在名称中随便输入一个本文输入zy,在引用位置中输入

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

最后点击确定。

4.在B2单元格输入公式 =LOOKUP(LEFT(A2,1),zy)&LOOKUP(MID(A2,2,1),zy)&LOOKUP(MID(A2,3,1),zy)&LOOKUP(MID(A2,4,1),zy) （注意此函数zy即上一步定义名称）即可完成