表格里面增加第一个汉子的字母怎么弄啊。谢谢
发布网友
发布时间:2024-08-18 21:54
我来回答
共2个回答
热心网友
时间:2024-08-23 02:08
不管是在什么表格里你把输入法切换一下,或者直接按住shift同时输入你想输入的字母就可以了,由于是大写的字母,输入完后可以继续打汉字的,试一下吧!可以的。
热心网友
时间:2024-08-23 02:13
在A1中输入公式下拉,B列中输入汉字,C列用文本连接比如:“=A1&B1”下拉,
A1=IF(ISERROR(LOOKUP(CODE(LEFT(B1,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(LEFT(B1,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"}))