WPS table three seconds to get the first letter of the word

Preview the Template:



In the daily work process, we often need to get the first letter of Chinese characters, for example, the students use the Sequencer dictionary search word, the hospital set up a drug inquiry system,KTVset up a song query system ... Is there a way to easily get the first letter of the word? As you all know ,ETandexcleThe Chinese data can be arranged by sequencer, which indicates that the spreadsheet has been able to discern the relationship between the first letter of Chinese pinyin and its position in the encoding system. As long as query the position of Chinese characters in the coding system, and tell the same sequencer of Chinese characters in the encoding of the starting position, the spreadsheet can be sequencer easy to get Chinese characters.
To get the first letter of the Chinese character in three seconds, open your WPS.Table the, try it with me!

First, open the original workbook, and paste the following nested formulas in the column that prepares the fill letter:

=lookup (CODE (A2), 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"})

In this formula, the CODEThe function is to query the numeric code for the first character of the word (string), which actually indicates the specific rank of the Chinese character in the code base .LOOKPThe function obtains the first letter of the Chinese character according to the starting position of the different sequencer Chinese characters in the code base.
whichA2Refers to the name of the cell in which the Chinese word is quoted, we can get the first letter corresponding to the previous two characters to be modified according to the actual situation.

If you want to obtain the corresponding letter of the second Chinese character, you can use theA2insteadMID (a2,2,1)That represents the first, or second, from the second start of the string. The specific formula is:

=lookup (CODE (MID a2,2,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"})


If you want to take a third and so on, that is:

=lookup (CODE (MID a2,3,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"})

Third, if you want to get the first two characters sequencer how to do? With&"will get the first to second Kanji Sequencer formula to merge." If you want to get the first three characters sequencer, use the "&"Merges the formulas that get the 第一、二、三个 Kanji Sequencer.

Gets the formula for the first three kanji sequencer of the string:
=lookup (CODE (A2), 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 ( MID (a2,2,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 ( MID (a2,3,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"})