根据中文提取汉字首字母。

在B1单元格输入

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

在C列中返回A列每个汉字的拼音首字母

[1]公式意义：

将A1单元格中的文本转换为拼音。

[2]函数解释：

PHONETIC：信息函数,提取文本字符串中的拼音字符。

[3]参数解释：

A1：需要转换为拼音的单元格，即小学

失败

希望可以在对话操作表格里面，增加一键获取汉字首字母类的操作流程。如新增智能表格中的智能抽取功能。