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

0卡拉卡拉0 2023-03-19 05:19

• 

  0时光机器0

  2023-03-19 06:02

  用函数或者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"})
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...