WPS怎么提取表格汉字首字母

小兵
小兵
WPS怎么提取表格汉字首字母的函数公式例如安溪佳艺通 提取后是AXJYT
WPS表格 WPS表格
福建省
浏览 1837
收藏
1
分享
1 +1
18
+1
全部评论 18
 
亂雲飛渡
亂雲飛渡

WPS寻令官

可以用VBA实现。 可参考：Excel中如何用函数实现提取汉字的首字母_360新知 https://xinzhi.wenda.so.com/m/a/1523443598618663
· 广东省
回复
小兵
感谢不过这个有点复杂了
· 福建省
回复
 
HC.旋
HC.旋

WPS寻令官

点赞
· 江苏省
回复
 
千叶
千叶
当然,如果觉得太乱的话, 用名称管理器把{"","";"吖","A";"八","B";"攃","C";"咑","D";"鵽","E";"发","F";"旮","G";"哈","H";"丌","J";"咔","K";"垃","L";"妈","M";"乸","N";"噢","O";"帊","P";"七","Q";"冄","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"} 组合命名 例如: 汉字机器编码 =CONCAT(VLOOKUP(MID(A2,SEQUENCE(LEN(A2)),1),汉字机器编码,2,TRUE))
· 江西省
回复
小兵
非常感谢
· 福建省
回复
查看更多评论
 
千叶
千叶
没有正则的: =CONCAT(VLOOKUP(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"},2,TRUE)) 正则: =CONCAT(VLOOKUP(REGEXP(A2,"."),{"","";"吖","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))
· 江西省
1
回复
小兵
这个才行
· 福建省
回复
查看更多评论