Current location - Recipe Complete Network - Healthy recipes - How to change Chinese characters in EXCEL into Pinyin?
How to change Chinese characters in EXCEL into Pinyin?
Preparation tools/materials: a computer with windows 10, Microsoft Office Home Edition and Student Edition 2007 excel software.

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.