wps提取每个字首字母答:在wps文字里,让文字显示拼音。然后在excel里,提取字母。1、给文字加拼音 2、拷到excel,可以看到带拼音的文字,再用公式显示拼音。D5公式=MID($B5,FIND(MID($C5,COLUMN(A1),1),$B5)+2,1)3、如果需要大写字母,可以加函数UPPER()D5公式=MID(UPPER($B5),FIND(MID($C5,COLUMN(A1),1),UPP...
WPS表格中如何只保留单词首字母?答:LOOKUP(CODE(A1),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",