用公式将汉字转换成拼音首字母

如何用公式将汉字转换成拼音首字母呢？看一下具体操作步骤吧。

材料/工具

excel

方法

步骤1

右击要转换首字母的单元格，选择定义名称。

步骤2

在名称处输入：PY
在引用位置处输入： ={"","吖","八","攃","咑","鵽","发","旮","哈","丌","咔","垃","妈","乸",
"噢","帊","七","冄","仨","他","屲","夕","丫","帀";"","A","B","C","D","E",
"F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}。

步骤3

在需转换结果的单元格输入：=LOOKUP(MID(A2,1,1),PY)&LOOKUP(MID(A2,2,1),PY)&LOOKUP(MID(A2,3,1),PY)&LOOKUP(MID(A2,4,1),PY)。

步骤4

如图所示，汉字已经转换为首字母拼写。

---

声明本文系本人根据真实经历原创，未经许可，请勿转载。