excel表格中文名字轉換英文

1. 怎麼在Excel中把中文名字轉換成英文的

ctrl+F，選擇替換，輸入要替換的中文名和英文名，然後確定即可，全文中的都可以替換，很方便

2. EXCEL 中如何將姓名轉換成英文格式

這個裡面有：http://jingyan..com/article/cd4c2979ee7808756e6e6085.html

3. Excel中，如何把中文名轉換成英文名比如A1單元格是周小明，B1單元格就需轉化成Xiaoming Zhou。

需要去下載一個PINYIN函數，然後進行轉換
至於格式規范，可以用UPPER(LEFT(拼音,1))&LOWER(RIGHT(拼音,LEN(拼音)-1))
而且，對於多音字，PINYIN函數可能會僅返回第一個讀音的拼音

4. Excel中如何將中文姓名按英文格式轉換

必須用VBA，代碼見：http://blog.sina.com.cn/s/blog_60f0dbfb0100e8bo.html
如果你對VBA完全沒有了解，還是把所有的名字發過來，我幫你轉（[email protected]）

5. excel 中怎麼樣把漢字轉換成英文簡稱

借用其他高手的回答：（以下公式為四個漢字內，再多還要加公式）
=LOOKUP(CODE(A1),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})&IF(LEN(A1)>1,LOOKUP(CODE(MID(A1,2,1)),45217+{-45185,0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"","A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")&IF(LEN(A1)>2,LOOKUP(CODE(MID(A1,3,1)),45217+{-45185,0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"","A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")&IF(LEN(A1)>3,LOOKUP(CODE(MID(A1,4,1)),45217+{-45185,0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"","A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")

6. excel中文文件怎麼轉換為英文

首先你要准備中文和英文資料各一份。放在EXCEL文檔中的不同的工作表中。
然後要用VBA，VBA裡面有一個打開文件就執行的函數。
使用這個函數，讓文件一打開就彈出一個選擇窗口。
如果選擇中文就顯示中文內容的工作表，隱藏英文內容的工作表。
英文則相反。

7. 如何將Excel表裡面的中文名字,換成英文,並區分大小寫…在線等。急用。

目標漢字： 漢字轉拼音舉例
1 顯示用空格分開的拼音
公式： =HzToPy($b$19," ")
結果： hàn zì zhuǎn pīn yīn jǔ lì
2 顯示用空格分開的拼音，同時不顯示注音符號
公式： =HzToPy($b$19," ",false)
結果： han zi zhuan pin yin ju li
3 顯示用空格分開的拼音，不顯示注音符號,同時僅顯示拼音的首字,並大寫
公式： =HzToPy($b$19," ",false，true，false)
結果： H Z ZH P Y J L
4 顯示用空格分開的拼音，不顯示注音符號,同時僅顯示拼音的首字母,並大寫
公式： =HzToPy($b$19," ",false，true)
結果： H Z Z P Y J L

8. 你好，我想問下EXCEL表格中怎麼把中文名字轉換為英文名字

必須有中英文名字對照表

B2=VLOOKUP(A2,$E$3:$F$20,2,0)向下復制

9. Excel中如何把中文名轉換成英文名比如A1單元格是曹小明，B1單元格就需轉化成XiaomingCao

用VBA ，只能出現漢字的拼音首個字母
除非你建立一一對應表，用VLOOKUP