如何去掉word或者Excel中拼音的声调

rthtjhr · 发表于 2019-8-9 15:12

拼音已经打出来了，求教各位大神怎么把声调去掉？

彭东岳	péngdōngyuè
谢帅帅	xièshuàishuài
程文祥	chéngwénxiáng
朱艺凡	zhūyìfán
肖玉杰	xiāoyùjié
范以峰	fànyǐfēng
刘云	liúyún
赵群堂	zhàoqúntáng
王明标	wángmíngbiāo
闫聪聪	yáncōngcōng
雷占胜	léizhànshèng
陈俊哲	chénjùnzhé

拼音佳佳 · 发表于 2019-8-11 00:10

你要做一个从é到e的表.韵母有6个,aoeiuv,音调4个,所以是24个字符.
你先把这一步做了,后面有高手帮你弄后续的.

libo5563 · 发表于 2019-8-11 22:04

建议楼主出门右转，Word 板块去看看想问下音调你怎么加上去的？

ggmmlol · 发表于 2019-8-13 08:35

āáǎà
ōóǒò
ēéěè
īíǐì
ūúǔù
ǖǘǚǜ

rthtjhr · 发表于 2019-8-22 17:26

拼音佳佳发表于 2019-8-11 00:10
你要做一个从é到e的表.韵母有6个,aoeiuv,音调4个,所以是24个字符.
你先把这一步做了,后面有高手帮你弄后 ...

谢谢不弄了太难了

sae666 · 发表于 2020-3-2 18:10

http://www.accessoft.com/article-show.asp?id=5505 这里面附件有个宏可以实现你

tommy05954 · 发表于 2020-3-2 19:31

用SUBSTITUTE函数

gmafhnpl · 发表于 2020-3-2 19:38

libo5563 发表于 2019-8-11 22:04
建议楼主出门右转，Word 板块去看看想问下音调你怎么加上去的？

word里面有个拼音指南，直接标上拼音的

gmafhnpl · 发表于 2020-3-2 19:39

用查找替换一个个来

杰玲荣 · 发表于 2020-9-21 15:27

不发网址了直接上公式从360图书馆那儿弄来的
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"ā","a"),"á","a"),"ǎ","a"),"à","a"),"ē","e"),"é","e"),"ě","e"),"è","e"),"ī","i"),"í","i"),"ǐ","i"),"ì","i"),"ō","o"),"ó","o"),"ǒ","o"),"ò","o"),"ū","u"),"ú","u"),"ǔ","u"),"ù","u"),"ǖ","ü"),"ǘ","ü"),"ǚ","ü"),"ǜ","ü")

		自动登录	找回密码
密码			免费注册

[求助] 如何去掉word或者Excel中拼音的声调