Excel name conversion pinyin formula: =getpy(), the specific steps are as follows:
1. First, open an Excel table on your computer. The names above are all made up by myself. If the name is the same as yours, it is purely coincidental.
2. We enter the Chinese characters converted to pinyin in cell D1 of the open table, and then enter the =getpy (A2) formula in cell D2. Because the name is on column A, you need to reference cell select A2.
3. After entering the formula and selecting the cell that references the name, press the OK key and you will see that the name has been converted to pinyin in cell D2.
4. Then select the pinyin name of cell D2 and pull down to convert the following cells.
5. Now you can see that the cells in column D have been converted to pinyin names. In order to better distinguish between uppercase and lowercase letters, we enter the corresponding Chinese characters as prompts in cell E1, and then enter the =PROPER (D2) formula in cell E2.
6. Finally, fill in the pinyin name of cell E2 downwards.
Extended information:
1. Two-column name verification
If you want to check whether the name in Table 2 appears in Table 1, you can do it immediately with a formula :=IF(COUNTIF(A:A,C2),"Yes","No")
2. Scale all columns to one page
When printing preview, there will be a The columns are displayed separately on another page. In fact, just set the zoom and zoom all the columns to one page.
3. Replace the entire workbook
To replace the data in the entire workbook, you can press Ctrl H to open the replacement dialog box, and then click Options - Range - Workbook. Replacement is done in all worksheets.
4. Fill merged cells
Quickly organize the worksheet with merged cells: Just select the data area and cancel the merged cells first. Then press Ctrl G to locate the null value. Then enter the equal sign, press the up arrow of the direction key, and finally press Ctrl and press Enter.
5. Set column width in millimeters
By default, the unit of row height and column width in Excel is points. If you want to set the row height in millimeters: click the page layout view button in the lower right corner of the worksheet, and then set the row height and column width. The unit is cm, which can be accurate to 0.02 cm.