Excel如何提取每个汉字的第一个字母?

Excel如何提取每个汉字的第一个字母，学会了，以后办公更方便。在日常办公中，时长需要用到筛选数据，对于有些拼音和五笔不太会的人，很是不方便。如果，能够有一种方法，提取每个汉字的第一个字母，那么筛选数据的时候，就会变得很简单了。

如何实现了？这里需要结合代码 函数

效果如下图所示

首先，我们需要在工作表中，调出“开发工具”，点击“Visual Basic”插入模块，在右面窗口中粘贴下面代码

代码如下所示：

Function hztopy(hzpy As String) As String

Dim hzstring As String, pystring As String

Dim hzpysum As Integer, hzi As Integer, hzpyhex As Integer

hzstring = Trim(hzpy)

hzpysum = Len(Trim(hzstring))

pystring = ""

For hzi = 1 To hzpysum

hzpyhex = "&H" Hex(Asc(Mid(hzstring, hzi, 1)))

Select Case hzpyhex

Case &HB0A1 To &HB0C4: pystring = pystring "A"

Case &HB0C5 To &HB2C0: pystring = pystring "B"

Case &HB2C1 To &HB4ED: pystring = pystring "C"

Case &HB4EE To &HB6E9: pystring = pystring "D"

Case &HB6EA To &HB7A1: pystring = pystring "E"

Case &HB7A2 To &HB8C0: pystring = pystring "F"

Case &HB8C1 To &HB9FD: pystring = pystring "G"

Case &HB9FE To &HBBF6: pystring = pystring "H"

Case &HBBF7 To &HBFA5: pystring = pystring "J"

Case &HBFA6 To &HC0AB: pystring = pystring "K"

Case &HC0AC To &HC2E7: pystring = pystring "L"

Case &HC2E8 To &HC4C2: pystring = pystring "M"

Case &HC4C3 To &HC5B5: pystring = pystring "N"

Case &HC5B6 To &HC5BD: pystring = pystring "O"

Case &HC5BE To &HC6D9: pystring = pystring "P"

Case &HC6DA To &HC8BA: pystring = pystring "Q"

Case &HC8BB To &HC8F5: pystring = pystring "R"

Case &HC8F6 To &HCBF9: pystring = pystring "S"

Case &HCBFA To &HCDD9: pystring = pystring "T"

Case &HEDC5: pystring = pystring "T"

Case &HCDDA To &HCEF3: pystring = pystring "W"

Case &HCEF4 To &HD1B8: pystring = pystring "X"

Case &HD1B9 To &HD4D0: pystring = pystring "Y"

Case &HD4D1 To &HD7F9: pystring = pystring "Z"

Case Else

pystring = pystring Mid(hzstring, hzi, 1)

End Select

Next

hztopy = pystring

End Function

然后在D2单元格中输入公式:=hztopy(A2)即可实现下图效果