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