步骤一:将下述
常量数组定义为名称,如PY,下面就是包括26个字母及其第一个汉字: ={"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";" 夻","J";"咔","K";"垃","L";"呒","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";" 仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}
复制公式或代码步骤二:使用LOOKUP(汉字,PY)或者VLOOKUP(汉字,PY,2)就可以返回指定汉字的拼音首字母:
(注意:使用VLOOKUP()函数时,其最后一个参数须用1或True的模糊“默认”查找方式)
如下,LOOKUP()的个数可根据汉字的个数决定,由于上面定义的PY最前面有一个""的值,所以可以屏蔽错误,当然也可以用迭代计算的方式获得: =LOOKUP(LEFT(A2),PY)&LOOKUP(