WPS Table tips Three seconds to get the first letter of a word

Preview the Template:

In the daily work process, we often need to get the first letter of Chinese characters, for example, students use Sequencer search Word dictionary, the hospital set up a drug inquiry system, KTV set up song query system ... Is there any way to easily get the first letter of the word? We all know that ET and excle can arrange Chinese data 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.

For three seconds to get the first letter of the Chinese character to open your WPS form 2012, 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 code function is designed to query the numeric code for the first character of the word (string), which in fact indicates the specific rank of the Chinese character in the code base, and the LOOKP function obtains the first letter of the Chinese character according to the starting position of the different sequencer characters in the code base.

Among them, A2 is the name of the cell that quotes the Chinese word, we can get the first letter corresponding to the two characters of the word according to the actual situation.

If you want to get the letter of the second Chinese character, you can change the A2 in the above formula to mid (a2,2,1), representing 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? "&" will get the first to second Chinese character Sequencer Formula merged. If you want to get the first three characters sequencer use "&" to merge the formula to get 第一、二、三个 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"})