我现在在做一个表格,需要把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","W","X","Y","Z"})&LOOKUP(CODE(RIGHT(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"})
以上公式给你备用,难说你以后又要用,算是给你备用吧!
但是根据你的题目要求,你并不需要所有汉字的首字母,比如你的C1是“机械”,那么B1需要为“J”;C2是“玩具”,那么B2需要为“W”。看来你的你只要第一个汉字的首字母,其他的都不要。只要则删除上面公式中&后面的部分即可。具体公式是(把以下公式复制粘贴入B1单元格,用填充柄往下拖公式即可):
=LOOKUP(CODE(LEFT(C1,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"})
如下图:
真诚希望能够帮助到你!当然上面有人已经用邮件和百度HI帮你解决。我不知道他是不是用我一样的方法,但我觉得,邮件其他人看不到,能够解决问题的答案应该共享,这样百度网络才会更美好,大家也才需要网络!-----河阳小子!