在Excel报格中，我想用A列输入每个人的姓名，怎样做才能在B列自动出现姓名的首字母

来源：百度知道 编辑：UC知道 时间：2024/06/08 09:55:13
哪个公式可以做到？？
我输入的姓名是汉字

IF函数好像不对！

B1用这个公式
=IF(ISERROR(A1),"",(LOOKUP(A1,{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"呒","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"})))

IF有问题的话你就直接
LOOKUP(A1,{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"