怎樣在excel表格中輸入中文,，用公司套出中文首字母，比如“無籽西瓜”,，自動(dòng)算出“wzxg”,，這樣

一個(gè)公式完美解決,，缺點(diǎn)是公式長(zhǎng)了一點(diǎn)，不處理多音字,。

公式只統(tǒng)計(jì)4個(gè)漢字及以下的，如果超過4個(gè)自行加長(zhǎng)公式即可,。每個(gè)多加一個(gè)字多加一串公式"&IFERROR(....4....)",，里面的數(shù)字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),"")

Tags：中文表格首字母

文章版權(quán)聲明：除非注明,，否則均為便查問答網(wǎng)原創(chuàng)文章,，轉(zhuǎn)載或復(fù)制請(qǐng)以超鏈接形式并注明出處。