【无标题】wps通过姓名获取拼音首字母

今天要往数据库插入数据，但是只有姓名还需要拼音吗，搜索了半天，发现有这么好用的方法。

在这里多谢百度百度问答！在这里记录下，方便下次使用。

公式如下：

=VLOOKUP(MID(A2,1,1),{"","";"吖","A";"八","B";"攃","C";"咑","D";"鵽","E";"发","F";"旮","G";"哈","H";"丌","J";"咔","K";"垃","L";"妈","M";"乸","N";"噢","O";"帊","P";"七","Q";"冄","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2,TRUE)&VLOOKUP(MID(A2,2,1),{"","";"吖","A";"八","B";"攃","C";"咑","D";"鵽","E";"发","F";"旮","G";"哈","H";"丌","J";"咔","K";"垃","L";"妈","M";"乸","N";"噢","O";"帊","P";"七","Q";"冄","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2,TRUE)&VLOOKUP(MID(A2,3,1),{"","";"吖","A";"八","B";"攃","C";"咑","D";"鵽","E";"发","F";"旮","G";"哈","H";"丌","J";"咔","K";"垃","L";"妈","M";"乸","N";"噢","O";"帊","P";"七","Q";"冄","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2,TRUE)

使用这个公式，A2就是姓名所在单元格的标识

然后，就可以如下显示拼音首字母。