再开垦缓助列“姓名个字字母”、“姓名二个字字母”、“姓名三个字字母”汕头管道保温施工，这里要用到个颠倒的公式：=VLOOKUP(B2,

{"","";"吖","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函数的区间匹配，旨趣是诳骗汉字的机器编码构成常量数组，用VLOOKUP函数的区间匹配复返对应的字母，设备保温施工不睬解这个旨趣的小伙伴也没干系，只需要复制上头的公式到对应的单位格，然后将参数的“B2”改成对应汉字的单位格位置就好

添加好后雷同下拉填充汕头管道保温施工，这么咱们通过缓助列依然基本就依然完成了姓名的统统字母索要