在工作的时候，需要我们将中文批量的修改成aclasstaghrefwiki10003IQMNVK01。html拼音a的格式来显示，利用excel中的宏，定义一个getpy方法可以轻松的实现，下面就介绍一下方法 操作方法 01：hr打开需要整理的表格数据，如下图 02：hr快捷键altf11，调出宏设置页面，选择插入中的模块选项 03：hr在出现的模块面板中，定义一个getpy的方法，将如下代码粘贴进去 Functionpinyin（pAsString）AsString iAsc（p） SelectCasei Case20319To20318：pinyina Case20317To20305：pinyinai Case20304To20296：pinyinan Case20295To20293：pinyinang Case20292To20284：pinyinao Case20283To20266：pinyinba Case20265To20258：pinyinbai Case20257To20243：pinyinban Case20242To20231：pinyinbang Case20230To20052：pinyinbao Case20051To20037：pinyinbei Case20036To20033：pinyinben Case20032To20027：pinyinbeng Case20026To20003：pinyinbi Case20002To19991：pinyinbian Case19990To19987：pinyinbiao Case19986To19983：pinyinbie Case19982To19977：pinyinbin Case19976To19806：pinyinbing Case19805To19785：pinyinbo Case19784To19776：pinyinbu Case19775To19775：pinyinca Case19774To19764：pinyincai Case19763To19757：pinyincan Case19756To19752：pinyincang Case19751To19747：pinyincao Case19746To19742：pinyince Case19741To19740：pinyinceng Case19739To19729：pinyincha Case19728To19726：pinyinchai Case19725To19716：pinyinchan Case19715To19541：pinyinchang Case19540To19532：pinyinchao Case19531To19526：pinyinche Case19525To19516：pinyinchen Case19515To19501：pinyincheng Case19500To19485：pinyinchi Case19484To19480：pinyinchong Case19479To19468：pinyinchou Case19467To19290：pinyinchu Case19289To19289：pinyinchuai Case19288To19282：pinyinchuan Case19281To19276：pinyinchuang Case19275To19271：pinyinchui Case19270To19264：pinyinchun Case19263To19262：pinyinchuo Case19261To19250：pinyinci Case19249To19244：pinyincong Case19243To19243：pinyincou Case19242To19239：pinyincu Case19238To19236：pinyincuan Case19235To19228：pinyincui Case19227To19225：pinyincun Case19224To19219：pinyincuo Case19218To19213：pinyinda Case19212To19039：pinyindai Case19038To19024：pinyindan Case19023To19019：pinyindang Case19018To19007：pinyindao Case19006To19004：pinyinde Case19003To18997：pinyindeng Case18996To18978：pinyindi Case18977To18962：pinyindian Case18961To18953：pinyindiao Case18952To18784：pinyindie Case18783To18775：pinyinding Case18774To18774：pinyindiu Case18773To18527：pinyindong Case18526To18519：pinyinfa Case18518To18502：pinyinfan Case18501To18491：pinyinfang Case18490To18479：pinyinfei Case18478To18464：pinyinfen Case18463To18449：pinyinfeng Case18448To18448：pinyinfo Case18447To18447：pinyinfou Case18446To18240：pinyinfu Case18239To18238：pinyinga Case18237To18232：pinyingai Case18231To18221：pinyingan Case18220To18212：pinyingang Case18211To18202：pinyingao Case18201To18185：pinyinge Case18184To18184：pinyingei Case18183To18182：pinyingen Case18181To18013：pinyingeng Case18012To17998：pinyingong Case17997To17989：pinyingou Case17988To17971：pinyingu Case17970To17965：pinyingua Case17964To17962：pinyinguai Case17961To17951：pinyinguan Case17950To17948：pinyinguang Case17947To17932：pinyingui Case17931To17929：pinyingun Case17928To17923：pinyinguo Case17922To17760：pinyinha Case17759To17753：pinyinhai Case17752To17734：pinyinhan Case17733To17731：pinyinhang Case17730To17722：pinyinhao Case17721To17704：pinyinhe Case17703To17702：pinyinhei Case17701To17698：pinyinhen Case17697To17693：pinyinheng Case17692To17684：pinyinhong Case17683To17677：pinyinhou Case17676To17497：pinyinhu Case17496To17488：pinyinhua Case17487To17483：pinyinhuai Case17482To17469：pinyinhuan Case17468To17455：pinyinhuang Case17454To17434：pinyinhui Case17433To17428：pinyinhun Case17427To17418：pinyinhuo Case17417To17203：pinyinji Case17202To17186：pinyinjia Case17185To16984：pinyinjian Case16983To16971：pinyinjiang Case16970To16943：pinyinjiao Case16942To16916：pinyinjie Case16915To16734：pinyinjin Case16733To16709：pinyinjing Case16708To16707：pinyinjiong Case16706To16690：pinyinjiu Case16689To16665：pinyinju Case16664To16658：pinyinjuan Case16657To16648：pinyinjue Case16647To16475：pinyinjun Case16474To16471：pinyinka Case16470To16466：pinyinkai Case16465To16460：pinyinkan Case16459To16453：pinyinkang Case16452To16449：pinyinkao Case16448To16434：pinyinke Case16433To16430：pinyinken Case16429To16428：pinyinkeng Case16427To16424：pinyinkong Case16423To16420：pinyinkou Case16419To16413：pinyinku Case16412To16408：pinyinkua Case16407To16404：pinyinkuai Case16403To16402：pinyinkuan Case16401To16394：pinyinkuang Case16393To16221：pinyinkui Case16220To16217：pinyinkun Case16216To16213：pinyinkuo Case16212To16206：pinyinla Case16205To16203：pinyinlai Case16202To16188：pinyinlan Case16187To16181：pinyinlang Case16180To16172：pinyinlao Case16171To16170：pinyinle Case16169To16159：pinyinlei Case16158To16156：pinyinleng Case16155To15960：pinyinli Case15959To15959：pinyinlia Case15958To15945：pinyinlian Case15944To15934：pinyinliang Case15933To15921：pinyinliao Case15920To15916：pinyinlie Case15915To15904：pinyinlin Case15903To15890：pinyinling Case15889To15879：pinyinliu Case15878To15708：pinyinlong Case15707To15702：pinyinlou Case15701To15682：pinyinlu Case15681To15668：pinyinlv Case15667To15662：pinyinluan Case15661To15660：pinyinlue Case15659To15653：pinyinlun Case15652To15641：pinyinluo Case15640To15632：pinyinma Case15631To15626：pinyinmai Case15625To15455：pinyinman Case15454To15449：pinyinmang Case15448To15437：pinyinmao Case15436To15436：pinyinme Case15435To15420：pinyinmei Case15419To15417：pinyinmen Case15416To15409：pinyinmeng Case15408To15395：pinyinmi Case15394To15386：pinyinmian Case15385To15378：pinyinmiao Case15377To15376：pinyinmie Case15375To15370：pinyinmin Case15369To15364：pinyinming Case15363To15363：pinyinmiu Case15362To15184：pinyinmo Case15183To15181：pinyinmou Case15180To15166：pinyinmu Case15165To15159：pinyinna Case15158To15154：pinyinnai Case15153To15151：pinyinnan Case15150To15150：pinyinnang Case15149To15145：pinyinnao Case15144To15144：pinyinne Case15143To15142：pinyinnei Case15141To15141：pinyinnen Case15140To15140：pinyinneng Case15139To15129：pinyinni Case15128To15122：pinyinnian Case15121To15120：pinyinniang Case15119To15118：pinyinniao Case15117To15111：pinyinnie Case15110To15110：pinyinnin Case15109To14942：pinyinning Case14941To14938：pinyinniu Case14937To14934：pinyinnong Case14933To14931：pinyinnu Case14930To14930：pinyinnv Case14929To14929：pinyinnuan Case14928To14927：pinyinnue Case14926To14923：pinyinnuo Case14922To14922：pinyino Case14921To14915：pinyinou Case14914To14909：pinyinpa Case14908To14903：pinyinpai Case14902To14895：pinyinpan Case14894To14890：pinyinpang Case14889To14883：pinyinpao Case14882To14874：pinyinpei Case14873To14872：pinyinpen Case14871To14858：pinyinpeng Case14857To14679：pinyinpi Case14678To14675：pinyinpian Case14674To14671：pinyinpiao Case14670To14669：pinyinpie Case14668To14664：pinyinpin Case14663To14655：pinyinping Case14654To14646：pinyinpo Case14645To14631：pinyinpu Case14630To14595：pinyinqi Case14594To14430：pinyinqia Case14429To14408：pinyinqian Case14407To14400：pinyinqiang Case14399To14385：pinyinqiao Case14384To14380：pinyinqie Case14379To14369：pinyinqin Case14368To14356：pinyinqing Case14355To14354：pinyinqiong Case14353To14346：pinyinqiu Case14345To14171：pinyinqu Case14170To14160：pinyinquan Case14159To14152：pinyinque Case14151To14150：pinyinqun Case14149To14146：pinyinran Case14145To14141：pinyinrang Case14140To14138：pinyinrao Case14137To14136：pinyinre Case14135To14126：pinyinren Case14125To14124：pinyinreng Case14123To14123：pinyinri Case14122To14113：pinyinrong Case14112To14110：pinyinrou Case14109To14100：pinyinru Case14099To14098：pinyinruan Case14097To14095：pinyinrui Case14094To14093：pinyinrun Case14092To14091：pinyinruo Case14090To14088：pinyinsa Case14087To14084：pinyinsai Case14083To13918：pinyinsan Case13917To13915：pinyinsang Case13914To13911：pinyinsao Case13910To13908：pinyinse Case13907To13907：pinyinsen Case13906To13906：pinyinseng Case13905To13897：pinyinsha Case13896To13895：pinyinshai Case13894To13879：pinyinshan Case13878To13871：pinyinshang Case13870To13860：pinyinshao Case13859To13848：pinyinshe Case13847To13832：pinyinshen Case13831To13659：pinyinsheng Case13658To13612：pinyinshi Case13611To13602：pinyinshou Case13601To13407：pinyinshu Case13406To13405：pinyinshua Case13404To13401：pinyinshuai Case13400To13399：pinyinshuan Case13398To13396：pinyinshuang Case13395To13392：pinyinshui Case13391To13388：pinyinshun Case13387To13384：pinyinshuo Case13383To13368：pinyinsi Case13367To13360：pinyinsong Case13359To13357：pinyinsou Case13356To13344：pinyinsu Case13343To13341：pinyinsuan Case13340To13330：pinyinsui Case13329To13327：pinyinsun Case13326To13319：pinyinsuo Case13318To13148：pinyinta Case13147To13139：pinyintai Case13138To13121：pinyintan Case13120To13108：pinyintang Case13107To13097：pinyintao Case13096To13096：pinyinte Case13095To13092：pinyinteng Case13091To13077：pinyinti Case13076To13069：pinyintian Case13068To13064：pinyintiao Case13063To13061：pinyintie Case13060To12889：pinyinting Case12888To12876：pinyintong Case12875To12872：pinyintou Case12871To12861：pinyintu Case12860To12859：pinyintuan Case12858To12853：pinyintui Case12852To12850：pinyintun Case12849To12839：pinyintuo Case12838To12832：pinyinwa Case12831To12830：pinyinwai Case12829To12813：pinyinwan Case12812To12803：pinyinwang Case12802To12608：pinyinwei Case12607To12598：pinyinwen Case12597To12595：pinyinweng Case12594To12586：pinyinwo Case12585To12557：pinyinwu Case12556To12360：pinyinxi Case12359To12347：pinyinxia Case12346To12321：pinyinxian Case12320To12301：pinyinxiang Case12300To12121：pinyinxiao Case12120To12100：pinyinxie Case12099To12090：pinyinxin Case12089To12075：pinyinxing Case12074To12068：pinyinxiong Case12067To12059：pinyinxiu Case12058To12040：pinyinxu Case12039To11868：pinyinxuan Case11867To11862：pinyinxue Case11861To11848：pinyinxun Case11847To11832：pinyinya Case11831To11799：pinyinyan Case11798To11782：pinyinyang Case11781To11605：pinyinyao Case11604To11590：pinyinye Case11589To11537：pinyinyi Case11536To11359：pinyinyin Case11358To11341：pinyinying Case11340To11340：pinyinyo Case11339To11325：pinyinyong Case11324To11304：pinyinyou Case11303To11098：pinyinyu Case11097To11078：pinyinyuan Case11077To11068：pinyinyue Case11067To11056：pinyinyun Case11055To11053：pinyinza Case11052To11046：pinyinzai Case11045To11042：pinyinzan Case11041To11039：pinyinzang Case11038To11025：pinyinzao Case11024To11021：pinyinze Case11020To11020：pinyinzei Case11019To11019：pinyinzen Case11018To11015：pinyinzeng Case11014To10839：pinyinzha Case10838To10833：pinyinzhai Case10832To10816：pinyinzhan Case10815To10801：pinyinzhang Case10800To10791：pinyinzhao Case10790To10781：pinyinzhe Case10780To10765：pinyinzhen Case10764To10588：pinyinzheng Case10587To10545：pinyinzhi Case10544To10534：pinyinzhong Case10533To10520：pinyinzhou Case10519To10332：pinyinzhu Case10331To10330：pinyinzhua Case10329To10329：pinyinzhuai Case10328To10323：pinyinzhuan Case10322To10316：pinyinzhuang Case10315To10310：pinyinzhui Case10309To10308：pinyinzhun Case10307To10297：pinyinzhuo Case10296To10282：pinyinzi Case10281To10275：pinyinzong Case10274To10271：pinyinzou Case10270To10263：pinyinzu Case10262To10261：pinyinzuan Case10260To10257：pinyinzui Case10256To10255：pinyinzun Case10254To10254：pinyinzuo CaseElse：pinyinp EndSelect EndFunction Functiongetpy（str） Fori1ToLen（str） getpygetpyamp；amp；pinyin（Mid（str，i，1）） Nexti EndFunction 04：hr保存后，选择关闭并返回表格选项 05：hr在B2单元格中输入getpy（A2）并回车，就转化成了拼音了 06：hr将鼠标放在B2单元格的右下方，指针变成是实心的十字时，按住鼠标左键向下拉，这样，所有的单元格就都应用上这个方法，变成拼音了
怎样让宝宝吃奶瓶宝宝不吃奶瓶怎么办工具材料不同类型的奶嘴及奶粉操作方法01：hr选择合适的喂奶时间：1。饥饿时。喂奶粉前2到3小时不给宝宝进食，让宝宝有饥饿感有食欲。2。想要睡觉时。先用母乳喂……长歌行阿隼的真实身份是中原人吗看过《长歌行》漫画的朋友都知道，阿隼的真实身份是契丹人。不过剧版似乎是对阿隼的身份进行了改动，从大可汗对涉尔说的那番话可以推断出，阿隼极有可能是中原人。如果真是这样，阿隼和大可……你满意性生活吗性博士当做运动会开心啲第8届香港性文化节于本周五至下周一（3月24日至27日）一连4日，在石硖尾赛马会创意艺术中心举行，今年主题是性跃动运动与性，期望与公众探讨性、性别、性文化及社会的关系。为……性爱时女人更要注重细节在性生活的过程中，男人虽然没有女人挑剔，但是有些细节还是非常在意的。而往往男人们在意的这些细节被女人所忽视。所以，性爱时，女人要注意一下男人们在意的这些细节，不要扫了男人的性致……女性多次性高潮对身体有害吗性高潮，是男女性爱时在意却喜爱的，只是有些女性却担心纵欲过度会伤害身体，她们很疑惑，如果一个晚上多次性爱皆达到了性高潮，会不会影响女性的身体健康，是否会有某些不良的影响。今天专……男人吃栗子的好处有什么生活中很多女性朋友特别喜欢吃坚果类的食物，男性朋友并不是特别喜欢。不过建议男性朋友在日常也可以适当的吃一些板栗。板栗口感美味，吃板栗不仅可以领略美味，同时可以帮助自身达到一个很……初中欧姆定律练习题题含答案吃透掌欧姆定律是初中物理会接触的一个知识点内容，也是考试的重点内容。初中物理作为一个非常重要的学科，所包含的知识点也是非常多的，如声学、力学、电学等，单看这些内容都不难，但是融合在一……冬天皮肤干燥瘙痒要先学会洗澡每天洗一次澡，这看起来很好的个人卫生习惯，在冬天并不适用。冬天洗澡太勤的话，我们的皮肤容易变干燥，从而引起瘙痒，想要缓解冬季皮肤干燥瘙痒，洗澡不能太勤。冬天洗澡不要太勤……手机拍照不好看这个功能一定要打开轻松我就是佩奇昨天11：24这几天，云南昆明大观楼的荷花开着正艳，加上前几天下过一次雨，可谓是拍摄荷花最好的时机。有的人一直跟小编抱怨，说自己拍摄的照片并不是非常好看，无论是……从微电影到短视频细讲内容创作的台前幕后作为内容创作领域的从业人与见证者，笔者将从多个维度盘点作为视频内容的发展历程以及背后的秘密。你是否对筷子兄弟还有印象？还记得那个只会背后阴人的猥琐男嘛？这部让无数人……企业家塑造个人品牌六大秘笈其实，品牌打造无论对于企业还是对于个人都尤其重要。改革开放以来，在中国经济发展的整个历程当中，企业品牌的成功一直伴随着企业家个人品牌塑造的成功，尤其是近年来互联网的快速发展，新……被分神剧碾碎三观名利双收还得靠骗01hr朋友聚会，三言两语，聊起上班遇到的那些满嘴跑火车的人。起因从小枫吐槽的一位同事说起。那同事Y与他关系不错，经常中午一起吃饭，后来两人同时有机会竞聘部门副经理……