公衆号好久沒用了，發個技術貼，如何word excel處理中文名字轉漢語拼音
第一步，将名字寫到word裡面，右鍵或者工具欄選擇拼音指南，完成後如下圖，每個人的姓名上出現拼音。
第二步，然後放到Excel表裡面，用公式=PHONETIC(C6) 提取拼音
第三步，用公式去掉聲調，
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(D6,"ǎ","a"),"ǐ","i"),"ī","i"),"ā","a"),"á","a"),"à","a"),"ē","e"),"é","e"),"ě","e"),"è","e"),"ū","u"),"ú","u"),"ǔ","u"),"ù","u"),"ō","o"),"ó","o"),"ǒ","o"),"ò","o"),"í","i"),"ì","i"),"ǖ","ü"),"ǘ","ü"),"ǚ","ü"),"ǜ","ü")
說明：關于韻母如何打出來可以用搜狗輸入法的特殊符号裡面的符号大全
zpostcode 
Recruit 
weather 
mreligion 
Yellowpages 
sport 
constellation 
shopping 
name 
game 
directory 
literature 
Word 
tour 
furnish 
Lottery 
tftnews 
lyrics 
News 
digital 
car 
dir 
Edu 
Finance 
