第一步：右击要转换首字母的单元格，选择定义名称 。
第二步：在名称处输入：PY在引用位置处输入： ={"","吖","八","攃","咑","鵽","发","旮","哈","丌","咔","垃","妈","乸","噢","帊","七","冄","仨","他","屲","夕","丫","帀";"","A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"} 。
第三步：在需转换结果的单元格输入：=LOOKUP(MID(A第二步：,第一步：,第一步：),PY)&LOOKUP(MID(A第二步：,第二步：,第一步：),PY)&LOOKUP(MID(A第二步：,第三步：,第一步：),PY)&LOOKUP(MID(A第二步：,第四步：,第一步：),PY) 。

文章插图
【excel公式汉字转换为大写拼音】第四步：如图所示，汉字已经转换为首字母拼写 。感谢大家对酷知识的支持，相关操作方法来源于网络，本篇内容主要是围绕excel公式汉字转换为大写拼音进行阐述,本文相关关键词还有:用公式将汉字转换成拼音首字母 。

• excel身份证号码提取出生日期年龄
• Excel表格输入公式不计算
• excel表格如何批量取消隐藏sheet表
• excel怎么把√方框里
• 京东购物触点的扣费公式是什么
• 日语里什么时候用汉字 对设立汉字日的看法
• 淘宝投入产出比计算公式
• 诗经取名字大全女孩名字免费
• 淘宝宝贝潜力值公式 淘宝宝贝潜力值怎么算
• 淘宝直通车权重算法公式是什么