HOW TO MENTION THE FIRST LETTER OF PINYIN 15 IN EXCEL

That's too troublesome, you tell me your mailbox, I'll give you a software, it's very easy to implement.

Excel is currently the most used software for data processing, and many office automation tools are used; In our study and life, we usually need to mark some Chinese characters with pinyin letters, which can be convenient for everyone to read, if you also have pinyin Chinese characters that need to be marked in your worksheet, I will tell you how to do it below.

How to enter phonetic letters in Excel1. First open the excel sheet, select the cells that need to be pinyinized, then click the "Start" tab, click the icon drop-down button of "Show or hide pinyin field" in the "Font" option group, and select the "Pinyin" command in the pop-up drop-down menu;

Figure 1 of the method of entering pinyin letters in excel2. After that, a text box will appear above the cell, and we will type the pinyin letter in it;

Excel method of entering pinyin letters step 2 3, after entering, click on other places and you will find that the pinyin just entered is not displayed, don't worry, you select the cell again or click the inverted triangle button of "show or hide pinyin field" in the "font" area, click "show pinyin" field command in the menu that appears;

The method of entering pinyin letters in excel steps Figure 3 4, at this time, the hidden pinyin will be displayed, if you want to change a color for the input pinyin letters, then select the cell again, click the "pinyin settings" command in the drop-down menu of "show or hide pinyin field";

The method of entering pinyin letters in excel is shown in Figure 4 5, click the "Font" tab in the pop-up dialog box, click the drop-down button behind in the "Color" area to select your favorite color, I choose pink here, and then click OK;

Excel method of entering pinyin letters step 5 6, after that even if it is successful, if you feel that the position of the entered pinyin does not match the position of the corresponding Chinese character, you can manually adjust it by the space bar, and the final result is as follows;

The method of entering pinyin letters in excel step 6 Guess you like: 1How to use Excel 2007 to annotate Chinese characters in pinyin.

2.How to enter 001 in excel2013

3.How to add pinyin to Chinese characters in excel2007.

4.How to enter 001 in excel

5.How to enter circles in Excel2013.

6.How to use excel2007 Chinese characters to pinyin function.

The steps are as follows: bai:du

Required materials: excel, excel capitalize the first letter of the function.

First, open DaoExcel, then press Alt+F11 to open the Viaual Basic, and click "Insert" in the toolbar.

Contain", and click "Module" in the drop-down menu.

2. Paste in the prepared capitalization function of the first letter of Pinyin and close the viaual basic device.

3. Go back to the excel interface, enter "=getpy(a1)" in the cell next to it to find the first letter of the pinyin capital of the a1 cell, followed by the last two digits of the b1 and c1 cells, then press the enter key to execute.

4. After pressing the enter key, you can get the result of LDH6582.

How to deal with polyphonic words, such as "朝", return "c" or "z"?