1, first open the document with officeExcel2007;
2. Mark the mouse in cell D2, enter the formula "=getpy(C2)", and then press enter to confirm;
3. We will see that the Chinese Pinyin in the name column will automatically appear;
4. Select cell D2, place the mouse in the lower right corner of the cell, and drag the mouse down when ""appears;
5. In this way, all Chinese characters in the name column are displayed in Pinyin.