How to batch convert Chinese characters into pinyin in excel2010

Time: 2017-07-25Source: Huajun InformationAuthor: youngest

 

step

1. Open an Excel table that needs to be converted (as shown in the picture, the editor has typed the names randomly, and any similarities are purely coincidental)

excel2010

2. Execute the "Tools → Macro → Visual Basic Editor" command, or directly press the "Alt+F11" key combination to enter the Visual Basic editing state. That is the gray editing interface used in the picture

excel2010

3. As shown in the figure, click the "Insert → Module" command

excel2010

Related articles更多>>

• What is the shortcut key for merging cells in Excel - Introduction to the shortcut keys for merging cells in Excel
• What are the Excel shortcut keys - Complete list of Excel shortcut keys
• Detailed steps for inserting blank rows based on the number of shoe sizes in an Excel table
• Steps to use to display famous quotes and aphorisms according to time patterns in Excel cells
• Detailed steps to quickly enter the ohm symbol in Excel
• Introducing the solution to the problem that Excel prompts that the file is damaged and cannot be opened when sharing a file
• A simple tutorial to pull out 1 to 100 in Excel
• How to undo illegal input values ​​in Excel tables
• Introduction to the specific operation of inserting rows every other row in Excel
• Detailed steps to set up Excel to automatically open files when it starts