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

打开【开发工具】菜单，点击第一个【Visual Basic】,弹出代码窗口，

在窗口左侧空白处，点击右键，选择【插入】->【模块】。窗口右侧出现一个白色背景框。

复制粘贴如下内容到右侧框中（虚线之间的内容，不含虚线）：

---------------------------------------------------------------------

Function getpychar(char)

    tmp = 65536 + Asc(char)

    If (tmp >= 45217 And tmp = 45253 And tmp = 45761 And tmp = 46318 And tmp = 46826 And tmp = 47010 And tmp = 47297 And tmp = 47614 And tmp = 48119 And tmp = 49062 And tmp = 49324 And tmp = 49896 And tmp = 50371 And tmp = 50614 And tmp = 50622 And tmp = 50906 And tmp = 51387 And tmp = 51446 And tmp = 52218 And tmp = 52698 And tmp = 52980 And tmp = 53679 And tmp = 54481 And tmp