有谁知道Excel中提取拼音的首字母的方法？

来源：百度知道 编辑：UC知道 时间：2024/06/17 06:04:19
我现在在做一个表格，需要把C列的文字的首字母提取到B列中去，怎么办呢？还有快捷的函数？谢谢大家。
比如我的C1是“机械”，那么B1需要为“J”；C2是“玩具”，那么B2需要为“W”。

你好，根据你的描述，你的问题可以由宏代码实现，当然也可以由函数公式直接实现，不过我觉得用函数公式实现更为简单。假如姓名在a1单元格，姓名为蒋彦斌三个字的，在任意单元格输入以下公式，会得出JYB的结果。公式如下：

=LOOKUP(CODE(LEFT(A1,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})&LOOKUP(CODE(RIGHT(A1,2)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T",&q