求助一个简单的函数或者公式

#写函数

ice y

创作者俱乐部成员

因为工作需要，所以需要提取员工的首字母拼音和员工的工号然后组成一个特定的编号。

有没有什么简单的公式可以快速实现啊！

测试文档在下面链接。

【金山文档 | WPS云文档】测试文档

https://kdocs.cn/l/cnUvoKxpgoSC

WPS表格函数公式

2024-07-31 02:51:02 四川省

7 +1

5 +1

全部评论 10

E精精

WPS函数专家

=CONCAT(LOOKUP(MID(A2,SEQUENCE(LEN(A2)),1),{"吖","A";"八","B";"攃","C";"咑","D";"妸","E";"发","F";"旮","G";"哈","H";"丌","J";"咔","K";"垃","L";"妈","M";"乸","N";"噢","O";"帊","P";"七","Q";"冄","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}))&B2