在Excel里面怎么自动提取字段的第一个汉字的拼音首字母

用函数或者vba(也可以装个插件工具箱)
函数的话，可以试试这两个
MID("ABCDEFGHJKLMNOPQRSTWXYZ",MATCH(LEFT(A1),{"啊","芭","擦","搭","蛾","发","噶","骸","击","喀","垃","妈","拿","哦","啪","期","然","撒","塌","挖","昔","压","匝"}),1)
或者
LOOKUP(LEFT(A1),{"吖","A";"八","B";"嚓","C";"咑","D";"妸","E";"发","F";"猤","G";"铪","H";"丌","J";"咔","K";"垃","L";"呒","M";"拏","N";"噢","O";"妑","P";"七","Q";"亽","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/v2vxx7v2jvff3fxry72.html