怎样在excel表格中输入中文，用公司套出中文首字母

关键字：excel 更新时间：2021-12-31 11:22:11 92次访问

怎样在excel表格中输入中文，用公司套出中文首字母，比如“无籽西瓜”，自动算出“wzxg”，这样

一个公式完美解决，缺点是公式长了一点，不处理多音字。

公式只统计4个汉字及以下的，如果超过4个自行加长公式即可。每个多加一个字多加一串公式"&IFERROR(....4....)"，里面的数字4是汉字位置。

B2公式如下：

=IFERROR(INDEX(LOOKUP(CODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),{45217,45253,45761,46318,46826,47010,47297,47777,48119,49062,49324,49896,50371,50614,50622,50906,51387,51446,52218,52698,52980,53689,54481},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),1),"")&IFERROR(INDEX(LOOKUP(CODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),{45217,45253,45761,46318,46826,47010,47297,47777,48119,49062,49324,49896,50371,50614,50622,50906,51387,51446,52218,52698,52980,53689,54481},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),2),"")&IFERROR(INDEX(LOOKUP(CODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),{45217,45253,45761,46318,46826,47010,47297,47777,48119,49062,49324,49896,50371,50614,50622,50906,51387,51446,52218,52698,52980,53689,54481},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),3),"")&IFERROR(INDEX(LOOKUP(CODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),{45217,45253,45761,46318,46826,47010,47297,47777,48119,49062,49324,49896,50371,50614,50622,50906,51387,51446,52218,52698,52980,53689,54481},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),4),"")

相关标签：excel