導讀今天給大家分享一下提取漢字拼音首字母的方法，比如把“黃蓉”轉換為“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即上一步定義名稱）即可完成