大向微博客-長大樂忧伤http://www.pmohcs.tw/大向微博客-長大樂忧伤www.pmohcs.tw 如何对含有回车的单元格进行分列?http://www.pmohcs.tw/system/excel0409.html<p>[操作与技巧]</p><p>如何对含有回车的单元格进行分列?</p><p>&nbsp;需要将特定的符号(如逗号)全部替换成软回车,网上找到以下方法,特此记录以备用啦</p><p>  1.如果在整个工作表中进行查找和替换,单击任何单元格取消选定的活动区域,不然只在活动区域进行,就有可能无法正确的找到数据。</p><p>  2.如果查找完整的单元格,需要选择“编辑”→“查找”或“替换?#20445;?#21462;消选择“单元格匹配?#20445;?#28982;后再重新搜索。</p><p>  3.如果要查找的数据是常数或者公式结果,就需要在“查找和替换”中的“查找范围”下拉框中选为值。如果数据包含公式或单元格批注中,需要从“查找范围”选择“公式”或“批注?#20445;?#25165;能准确找到需要的数据。</p><p>一、查找excel单元格中的换行符(alt + enter)<br/> 在excel中要批量查找软回车(alt + enter)可以通过在查找框内(通过按ctrl + f调出)输入:按住alt键不放,然后依次通过数字键盘输入1和0两个数字,放开数字键后再放开alt键。<br/> 注意:<br/>1、输入以上按键时查找框内看不到变化,但没关系,不要多输,也不要输少了;<br/>2、如果是用笔记本电脑,也不要用数字键输入10,必须调用字母按键上的数?#20013;?#38190;盘才行。</p><p>二、批?#21487;?#38500;或替换换行符(alt + enter)<br/> 知道怎么查找后,这个就容易了。<br/> 调出“查找和替换”框(可直接按ctrl + h调出),在查找内容框内按以上方法输入,在替换内容框中输入你要替换成的内容,如果不输入内容则为删除查找的内容。</p><p></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/system/excel0409.html" target="_blank">继续阅读《如何对含有回车的单元格进行分列?》的全文内容...</a></p><p>分类: 操作系统技巧 | Tags: <a href="http://www.pmohcs.tw/tag/excel">excel</a>, | <a href="http://www.pmohcs.tw/system/excel0409.html#comment" target="_blank">添加评论</a>(4)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/system/excel0409.html#comment-266">2019-04-18 15:40:51 PM</a>,日月赚 : 如果能配点图 应该更好些</li><li><a href="http://www.pmohcs.tw/system/excel0409.html#comment-267">2019-04-19 19:00:11 PM</a>,热血学霸 : 好好学习,天天向上</li><li><a href="http://www.pmohcs.tw/system/excel0409.html#comment-269">2019-05-07 15:30:18 PM</a>,文娱帝国 : 写的很好,支持下</li><li><a href="http://www.pmohcs.tw/system/excel0409.html#comment-270">2019-05-11 23:01:41 PM</a>,新闻头条 : 文章不错非常?#19981;叮?#25903;持</li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/system/excel20161114.html">excel表格数据全部变成了日期格式</a> (2016-11-14) </li><li><a href="http://www.pmohcs.tw/software/model.html">excel中把汉字转换成拼音</a> (2018-07-09) </li><li><a href="http://www.pmohcs.tw/software/tongji20171031.html">Excel中周统计数据的技巧</a> (2017-10-31) </li><li><a href="http://www.pmohcs.tw/software/word20170310.html">word与EXCEL单元格链接更新时产生回车的解决</a> (2017-02-10) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Tue, 09 Apr 2019 20:04:40 +0800 解决电脑文件或文件夹右上角出现两个箭头http://www.pmohcs.tw/system/arrow.html<p>&nbsp;桌面图标右上角出现蓝色箭头,单个右键可去除,无法批量去除,新建文档和文件夹时?#21482;?#20986;?#20013;?#30340;箭头。<br/><br/>解决这个问题是分两种情况:<br/><br/>一、解决桌面已经存在的?#36710;?#20010;文件和文件夹或多个文件和文件夹出现两个蓝色对角箭头:<br/>解决办法:选择单个文件和文件夹或多个文件和文件夹,点击“属性?#20445;?#22312;“常规”选项卡中的属于项中选择“高级?#20445;?#20986;现高级属性对话框之后选择?#25226;?#32553;或?#29992;?#23646;性”取消?#25226;?#32553;内容以便节省磁盘空间(C)?#20445;?#28857;击“确定?#20445;?#36820;回“文件属性”对话框,点“应用”再点击“确定”。<br/>二、解决在桌面原来不存在,需要新建文件或文件夹时出现两个蓝色对角箭头:<br/>解决办法:双击“我的电脑?#20445;?#36873;择“C盘?#20445;?#28857;击“看查”/“选项”出现“文件夹选项?#20445;?#36873;择:“查看”取消“隐藏文件和文件?#23567;?#21069;的勾,选择“显示隐藏的文件、文件夹和驱动器?#20445;?#28857;击“确定?#20445;?#29616;在在C盘下可以看到一个”用户“文件夹,双击”用户“,选择现在正在使用的用户名,例如Administrator,双击用户名,找到该文件夹下的”桌面“或”Desktop“点击“属性?#20445;?#22312;“常规”选项卡中的属于项中选择“高级?#20445;?#20986;现高级属性对话框之后选择?#25226;?#32553;或?#29992;?#23646;性”取消?#25226;?#32553;内容以便节省磁盘空间(C)?#20445;?#28857;击“确定?#20445;?#36820;回“文件属性”对话框,点“应用”再点击“确定”。<img title="1111.jpg" alt="1111.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2019/04/20190403143430_59785.jpg"/></p><p><br/></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/system/arrow.html" target="_blank">继续阅读《解决电脑文件或文件夹右上角出现两个箭头》的全文内容...</a></p><p>分类: 操作系统技巧 | Tags: <a href="http://www.pmohcs.tw/tag/%E7%94%B5%E8%84%91">电脑</a>, | <a href="http://www.pmohcs.tw/system/arrow.html#comment" target="_blank">添加评论</a>(0)</p><p><a href="http://www.pmohcs.tw/system/arrow.html#comment" target="_blank">还没有评论,您?#27492;?#20004;句?</a></p><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/diannaojiqiao/xiaojiqiao.html">电脑小技巧70个</a> (2013-07-09) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Sun, 03 Mar 2019 14:32:22 +0800 win10去除此电脑默认7文件夹/win10还原此电脑默认7文件夹http://www.pmohcs.tw/system/computerfiles.html<p>根据需求&nbsp;把下列代码 保存到TXT文?#36947;?#38754;,然后将.txt格式修改为.reg 保存后,双击执行;win10去除此电脑默认7文件夹,win10还原此电脑默认7文件?#23567;?lt;/p><p style="line-height: 16px;"><a title="win10还原我的电脑7个文件夹.reg.zip" style="color: rgb(0, 102, 204); font-size: 12px;" href="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2019/03/20190325170929_27643.zip">win10还原我的电脑7个文件夹.reg.zip</a></p><p style="line-height: 16px;"><a title="win10去除我的电脑7个文件夹.reg.zip" style="color: rgb(0, 102, 204); font-size: 12px;" href="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2019/03/20190325170930_19917.zip">win10去除我的电脑7个文件夹.reg.zip</a></p><p><img width="1617" height="248" title="23132.jpg" style="width: 1002px; height: 154px;" alt="23132.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2019/03/20190325165641_48167.jpg"/></p><p><br/></p><p><span style="font-size: 18px;"><strong>1,win10去除此电脑默认7文件夹</strong></span></p><p><br/></p><p>Windows Registry Editor Version 5.00</p><p><br/>;如需还原去除上语句前减号即可</p><p><br/>;取消我的电脑&quot;视频&quot;文件夹</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{f86fa3ab-70d2-4fc7-9c99-fcbf05467f3a}]</p><p><br/>;取消我的电脑&quot;文档&quot;文件夹</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{d3162b92-9365-467a-956b-92703aca08af}]</p><p><br/>;取消我的电脑&quot;桌面&quot;文件夹</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{B4BFCC3A-DB2C-424C-B029-7FE99A87C641}]</p><p><br/>;取消我的电脑&quot;音乐&quot;文件夹?</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{3dfdf296-dbec-4fb4-81d1-6a3438bcf4de}]</p><p><br/>;取消我的电脑&quot;下载&quot;文件夹</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{088e3905-0323-4b02-9826-5d99428e115f}]</p><p><br/>;取消我的电脑&quot;图片&quot;文件夹</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{24ad3ad4-a569-4530-98e1-ab02f9417aa8}]</p><p><br/>;取消我的电脑&quot;3D对象&quot;文件夹</p><p>[-HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{0DB7E03F-FC29-4DC6-9020-FF41B59E513A}]<br/></p><p><br/></p><p><span style="font-size: 18px;"><strong>2,win10还原此电脑默认7文件夹</strong></span></p><p><span style="font-size: 18px;"><strong><span style="font-size: 12px;"></span></strong><span style="font-size: 12px;"><br/></span></span></p><p>Windows Registry Editor Version 5.00</p><p><br/>;还原我的电脑中以下文件夹</p><p><br/>;还原我的电脑&quot;视频&quot;文件夹</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{f86fa3ab-70d2-4fc7-9c99-fcbf05467f3a}]</p><p><br/>;还原我的电脑&quot;文档&quot;文件夹</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{d3162b92-9365-467a-956b-92703aca08af}]</p><p><br/>;还原我的电脑&quot;桌面&quot;文件夹</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{B4BFCC3A-DB2C-424C-B029-7FE99A87C641}]</p><p><br/>;还原我的电脑&quot;音乐&quot;文件夹?</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{3dfdf296-dbec-4fb4-81d1-6a3438bcf4de}]</p><p><br/>;还原我的电脑&quot;下载&quot;文件夹</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{088e3905-0323-4b02-9826-5d99428e115f}]</p><p><br/>;还原我的电脑&quot;图片&quot;文件夹</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{24ad3ad4-a569-4530-98e1-ab02f9417aa8}]</p><p><br/></p><p>;还原我的电脑&quot;3D对象&quot;文件夹</p><p>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace\{0DB7E03F-FC29-4DC6-9020-FF41B59E513A}]<br/></p><p><span style="font-size: 18px;"><span style="font-size: 12px;"><br/></span></span></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/system/computerfiles.html" target="_blank">继续阅读《win10去除此电脑默认7文件夹/win10还原此电脑默认7文件?#23567;?#30340;全文内容...</a></p><p>分类: 操作系统技巧 | Tags: <a href="http://www.pmohcs.tw/tag/%E6%96%87%E4%BB%B6%E5%A4%B9">文件夹</a>, | <a href="http://www.pmohcs.tw/system/computerfiles.html#comment" target="_blank">添加评论</a>(3)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/system/computerfiles.html#comment-261">2019-03-30 15:13:06 PM</a>,文娱帝国 : 写的很好,很?#19981;?lt;/li><li><a href="http://www.pmohcs.tw/system/computerfiles.html#comment-262">2019-04-01 23:07:50 PM</a>,今日新闻 : 文章不错非常?#19981;?lt;/li><li><a href="http://www.pmohcs.tw/system/computerfiles.html#comment-265">2019-04-02 12:50:34 PM</a>,旋转门 : 原来还得这样操作</li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/system/20141125SSD.html">固态?#25165;蘏SD安装WIN7系?#36710;?#21150;法</a> (2014-11-25) </li><li><a href="http://www.pmohcs.tw/system/1013-windows10.html">Windows10降级教程:降至Win7/Win8.1</a> (2016-10-13) </li><li><a href="http://www.pmohcs.tw/system/jietu20180306.html">截图工具当前未在计算机上运行 请重新启动计算机,然后重试 如果问题?#20013;?#23384;在,请与你的系统管理员联系</a> (2018-02-27) </li><li><a href="http://www.pmohcs.tw/system/juyuwang0828.html">win7系统看不到局域网其他计算机</a> (2016-08-28) </li><li><a href="http://www.pmohcs.tw/system/160629SSID.html">隐藏SSID广播</a> (2016-06-29) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Fri, 22 Feb 2019 16:52:50 +0800 COUNTIFS函数使用技巧二(COUNTIFS一列某个字段数量以及COUNTIFS大于小于统计)http://www.pmohcs.tw/diannaojiqiao/COUNTIFS2.html<p><span class="ask-title">1,EXCEL中如何</span><span class="ask-title"></span><span class="ask-title">统计某一列中等于</span><span class="ask-title">某值并且另外一列中包含某个字段的单元格的数目</span></p><p><span class="ask-title">关键字段前后需添加&nbsp;&quot;*&nbsp; *&quot;(统计一列,统计某一列)</span></p><p><span class="ask-title">例如取杭州字段:</span></p><p><span class="ask-title">=COUNTIFS(A:A,&quot;*杭州*&quot;)</span></p><p><span class="ask-title">注意countifs是2007及以上版本才可用的函数</span></p><p><span class="ask-title"><img width="539" height="324" title="1.jpg" style="width: 280px; height: 192px;" alt="1.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2019/03/20190325154357_74445.jpg"/>,</span></p><p><span class="ask-title"><br/></span></p><p><span class="ask-title">2,<span class="ask-title">EXCEL中COUNTIF函数怎么计算大于且小于特定值的个数</span></span></p><p><span class="ask-title">例如大于60小于等于80</span></p><p><span class="ask-title">=COUNTIFS(D:D,&quot;&lt;=80&quot;,D:D,&quot;&gt;60&quot;)</span></p><p><span class="ask-title"><br/></span></p><p><span class="ask-title"><img width="324" height="576" title="222.jpg" style="width: 211px; height: 433px;" alt="222.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2019/03/20190325155534_46236.jpg"/></span></p><p><span class="ask-title"><br/></span></p><p><span class="ask-title"><br/></span></p><p><span class="ask-title"><br/></span></p><p><span class="ask-title"><span style="color: #0000CC;"><br/></span></span></p><p><span class="ask-title"><br/></span></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/diannaojiqiao/COUNTIFS2.html" target="_blank">继续阅读《COUNTIFS函数使用技巧二(COUNTIFS一列某个字段数量以及COUNTIFS大于小于统计)》的全文内容...</a></p><p>分类: 技巧知识 | Tags: <a href="http://www.pmohcs.tw/tag/COUNTIFS">COUNTIFS</a>, | <a href="http://www.pmohcs.tw/diannaojiqiao/COUNTIFS2.html#comment" target="_blank">添加评论</a>(1)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/diannaojiqiao/COUNTIFS2.html#comment-263">2019-04-01 23:09:00 PM</a>,今日新闻 : 文章不错支持一下</li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/software/COUNTIFS.html">COUNTIFS函数使用技巧一(COUNTIFS统计个数以及COUNTIFS统计非空值)</a> (2017-11-09) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Tue, 01 Jan 2019 15:39:11 +0800 安装32位Office 2016 出现 Office 16 Click-to-Run Extensibility Componenthttp://www.pmohcs.tw/software/Office16.html<p>之前安装64位office2016,后来?#23545;?#20934;备安装32位的,安装时提示&nbsp;安?#25353;?#35823;<br/>无法安装 64 ?#35805;?#26412;的 Office,因为在您的 PC 上找到了以下 32 位程序:Office 16 Click-to-Run Extensibility Component<br/>请?#23545;?#25152;有 32 位 Office 程序,然后重试安装 64 位 Office。如果想要安装 32 位 Office,请运行 32 ?#35805;?#35013;程序。<br/></p><p>解决方法:<br/></p><p>winkey+r 输入regedit,打开注册表,依次定位到 HKEY_CLASSES_ROOT\Installer\Products,</p><p>然后点开Products后,会出现以“00006”开头注册表键值</p><p>看下这些“00006”,右边观察键值就能不能看到“Office 16 Click-to-Run Extensibility Component”,如果能看到,直接把这些”00006“删除就好;然后重新点击安装就可以了。<br/></p><p>&nbsp;<img title="234.jpg" alt="234.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/12/20181225122404_80409.jpg"/></p><p>&nbsp;</p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/software/Office16.html" target="_blank">继续阅读《安装32位Office 2016 出现 Office 16 Click-to-Run Extensibility Component》的全文内容...</a></p><p>分类: 软件技巧 | Tags: <a href="http://www.pmohcs.tw/tag/Office">Office</a>, | <a href="http://www.pmohcs.tw/software/Office16.html#comment" target="_blank">添加评论</a>(2)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/software/Office16.html#comment-257">2019-02-22 13:44:56 PM</a>,访客 : 不错,管用,?#34892;?lt;/li><li><a href="http://www.pmohcs.tw/software/Office16.html#comment-258">2019-03-17 21:15:04 PM</a>,丘八 : 文章不错,非常?#19981;?lt;/li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/software/MATCH.html">EXCEL根据行列值查询得到交叉点值</a> (2018-04-30) </li><li><a href="http://www.pmohcs.tw/software/word20170310.html">word与EXCEL单元格链接更新时产生回车的解决</a> (2017-02-10) </li><li><a href="http://www.pmohcs.tw/software/suersen-Reade.html">书生阅览器不能打开SEP,GD?#20219;?#20214;解决方法</a> (2017-08-15) </li><li><a href="http://www.pmohcs.tw/software/bohaozhuli.html">苹果拨号助理导致打电话时提示“尚未开通国际及港澳台业务”</a> (2018-01-30) </li><li><a href="http://www.pmohcs.tw/software/MSXML0629.html">win7下安装Office2010老是出现提示安装MSXML6.10.1129.0,下载官方MSXML6</a> (2016-06-29) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Tue, 25 Dec 2018 12:17:46 +0800 win10查询自己电脑无线网密码方法http://www.pmohcs.tw/system/wifii.html<p>&nbsp;win10查询自己电脑无线网密码方法</p><p>方法1:win7 win10 xp已连接当前无线网络</p><p>win7:右下角 有线/无线 图标 点击,弹出无线网列表, 对已连接的无线网右键属性,打开无线网络属性之后,找到“<strong>安全”选项卡---“显示字符</strong>”即可查看当前的无线网密码。</p><p><img width="452" height="567" title="5555.jpg" style="width: 160px; height: 324px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181112112338_61178.jpg"/><img width="464" height="616" title="222.jpg" style="width: 165px; height: 319px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181112112337_53925.jpg"/></p><p>win10:右下角 有线/无线 图标 点击右键,打开 网络和Internet设置,选择更改适配器设置。 &nbsp;找到无线网的适配器。 &nbsp;右键状态,弹出窗口,选择无线网络属性,之后窗口,找到“<strong>安全”选项卡---“显示字符</strong>”即可查看当前的无线网密码。(此方法也使用win7)</p><p><br/></p><p><img width="559" height="203" title="3333.jpg" style="width: 241px; height: 142px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181112112337_30666.jpg"/></p><p>方法1:win7 win10 xp以前连接的无线网络,查找无线网密码</p><p>win7: 右下角 有线/无线 图标 点击右键,打开网络和共享?#34892;模?amp;nbsp; 选择 管理无线网络&nbsp;,找到你以前连接过的无线网名称,右键属性,选择无线网络属性,之后窗口,找到“<strong>安全”选项卡---“显示字符</strong>”即可查看当前的无线网密码。</p><p><img width="597" height="464" title="666.jpg" style="width: 243px; height: 206px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181112112338_68462.jpg"/></p><p><br/></p><p><img width="743" height="481" title="7777.png" style="width: 399px; height: 271px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181112112338_97019.png"/></p><p>win10:</p><p>开始菜单找到 命令提示符 或者win+R打开运行输入CMD,</p><p>输入1?#22909;?#20196;提示符中输入netsh wlan show profile&nbsp;&nbsp;&nbsp;,然后回车,查询出当前记录过的无线网名称</p><p>输入2:在命令提示符中输入 netsh wlan export profile name=&quot;需要查密码的wifi名称&quot; folder=. key=clear&nbsp;&nbsp;&nbsp;(示例以无线网名称ibolg:netsh wlan export profile name=&quot;ibolg&quot; folder=. key=clear)</p><p>得出3,:输入2回车后得出一个XML文件以及当前路径!(C盘的windows文件里面的System32中的WLAN-ibolg.xml 或者有些在C:\Users\电脑用户名\ 这个目录里面&nbsp;)</p><p>找到此文件,右键使用记事本打开或者双击使用网页打开, 打开后找到如下位置加粗字体的位置就是无线网的密码。</p><p>&lt;keyType&gt;passPhrase&lt;/keyType&gt;</p><p>&lt;protected&gt;false&lt;/protected&gt;</p><p>&lt;keyMaterial&gt;<strong>8888888</strong>&lt;/keyMaterial&gt;</p><p>&nbsp;</p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/system/wifii.html" target="_blank">继续阅读《win10查询自己电脑无线网密码方法》的全文内容...</a></p><p>分类: 操作系统技巧 | Tags: <a href="http://www.pmohcs.tw/tag/WIFI">WIFI</a>, | <a href="http://www.pmohcs.tw/system/wifii.html#comment" target="_blank">添加评论</a>(3)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/system/wifii.html#comment-251">2018-11-19 23:54:16 PM</a>,新闻 : 文章不错非常?#19981;?lt;/li><li><a href="http://www.pmohcs.tw/system/wifii.html#comment-254">2018-12-14 10:11:55 AM</a>,江苏GRC构件 : 没事可以在你这里学习学习</li><li><a href="http://www.pmohcs.tw/system/wifii.html#comment-264">2019-04-02 11:53:57 AM</a>,旋转门 : 如果忘了是一件真尴尬的事情</li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/system/UEFIBOIS1603.html">预装win8/10系?#36710;?#26032;型主板的新机器无法安装win7的问题</a> (2016-03-16) </li><li><a href="http://www.pmohcs.tw/system/20141102shadu.html">系统自带的最不起眼但又是最强的杀毒工具</a> (2014-11-02) </li><li><a href="http://www.pmohcs.tw/system/201604desktop.html">电脑开机一直准备桌面</a> (2016-04-03) </li><li><a href="http://www.pmohcs.tw/system/20141105wifi.html">?#24551;?#26080;线路由器网络安全性</a> (2014-11-05) </li><li><a href="http://www.pmohcs.tw/system/excel0409.html">如何对含有回车的单元格进行分列?</a> (2019-04-09) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Mon, 12 Nov 2018 11:23:20 +0800 flash helper service进程广告解决方法http://www.pmohcs.tw/software/Flash.html<p>flash helper service进程广告解决方法&nbsp;</p><p>新版的adobe flash player 30已经莫名的多了一个flashhelperservice进程,签名系重庆某某橙网络!发现adobe flash player已经出了国内特供版了,相比国际版,多了一个flashhelperservice进程,据说是用来收集用户信息的(特供版针对国内用户质疑,目前已经把用户信息收集条款改得很隐蔽了)!如果还在用29版本的,暂时还是用29版的吧,稳妥一点,至少没那个flashhelperservice进程!</p><p><img width="329" height="351" title="11.jpg" style="width: 178px; height: 299px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181115133551_33095.jpg"/></p><p><img width="322" height="163" title="2222.jpg" style="width: 216px; height: 155px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/11/20181115133551_24328.jpg"/></p><p>关闭方法:</p><p>安装完后,在任务管理器里找到Flash Player Helper Service 进程。<br/>然后打开Flash Player Helper Service 文件夹位置定位文件。<br/>C:\Windows\SysWow64\Macromed\Flash\FlashHelperService.exe <br/>然后<br/>先 在任务管理器里继续右键--结束进程树。<br/>后 在文件夹里删除\FlashHelperService.exe</p><p>关闭Flash Player Helper Service</p><p>在键盘上同时点击“win+R”键弹出运行界面,输入services.msc,点击“确定<br/>弹出服务的界面,找到“Flash Helper Service”右键属性禁用!<br/></p><p><span style="font-family: 宋体,SimSun; font-weight: bold;"><br/></span></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/software/Flash.html" target="_blank">继续阅读《flash helper service进程广告解决方法》的全文内容...</a></p><p>分类: 软件技巧 | Tags: <a href="http://www.pmohcs.tw/tag/flash">flash</a>, | <a href="http://www.pmohcs.tw/software/Flash.html#comment" target="_blank">添加评论</a>(0)</p><p><a href="http://www.pmohcs.tw/software/Flash.html#comment" target="_blank">还没有评论,您?#27492;?#20004;句?</a></p><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/software/tongji20171031.html">Excel中周统计数据的技巧</a> (2017-10-31) </li><li><a href="http://www.pmohcs.tw/software/excel1.html">EXCEL常用技巧1</a> (2017-09-29) </li><li><a href="http://www.pmohcs.tw/software/MSXML0629.html">win7下安装Office2010老是出现提示安装MSXML6.10.1129.0,下载官方MSXML6</a> (2016-06-29) </li><li><a href="http://www.pmohcs.tw/software/qiye163.html">网易163企业邮箱出现服务器不稳定,按?#25214;?#19979;要求反馈给kf@qiye.163.com</a> (2017-05-17) </li><li><a href="http://www.pmohcs.tw/software/suersen-Reade.html">书生阅览器不能打开SEP,GD?#20219;?#20214;解决方法</a> (2017-08-15) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Mon, 08 Oct 2018 13:20:05 +0800 excel中把汉字转换成拼音http://www.pmohcs.tw/software/model.html<p>&nbsp;</p><div class="content-list-text"><p>在本地电脑中,打开excel,启动Excel 2010,打开相应的工作表,同时按“Alt+F11”组合键,进入Visual Basic编辑状态,选择插入---模块</p><p>?#31895;?#24182;?#30424;?#19968;下内容到上一步打开的编辑界面中。</p><p>Function pinyin(p As String) As String</p><p>i = Asc(p)</p><p>Select Case i</p><p>Case -20319 To -20318: pinyin = &quot;a &quot;</p><p>Case -20317 To -20305: pinyin = &quot;ai &quot;</p><p>Case -20304 To -20296: pinyin = &quot;an &quot;</p><p>Case -20295 To -20293: pinyin = &quot;ang &quot;</p><p>Case -20292 To -20284: pinyin = &quot;ao &quot;</p><p>Case -20283 To -20266: pinyin = &quot;ba &quot;</p><p>Case -20265 To -20258: pinyin = &quot;bai &quot;</p><p>Case -20257 To -20243: pinyin = &quot;ban &quot;</p><p>Case -20242 To -20231: pinyin = &quot;bang &quot;</p><p>Case -20230 To -20052: pinyin = &quot;bao &quot;</p><p>Case -20051 To -20037: pinyin = &quot;bei &quot;</p><p>Case -20036 To -20033: pinyin = &quot;ben &quot;</p><p>Case -20032 To -20027: pinyin = &quot;beng &quot;</p><p>Case -20026 To -20003: pinyin = &quot;bi &quot;</p><p>Case -20002 To -19991: pinyin = &quot;bian &quot;</p><p>Case -19990 To -19987: pinyin = &quot;biao &quot;</p><p>Case -19986 To -19983: pinyin = &quot;bie &quot;</p><p>Case -19982 To -19977: pinyin = &quot;bin &quot;</p><p>Case -19976 To -19806: pinyin = &quot;bing &quot;</p><p>Case -19805 To -19785: pinyin = &quot;bo &quot;</p><p>Case -19784 To -19776: pinyin = &quot;bu &quot;</p><p>Case -19775 To -19775: pinyin = &quot;ca &quot;</p><p>Case -19774 To -19764: pinyin = &quot;cai &quot;</p><p>Case -19763 To -19757: pinyin = &quot;can &quot;</p><p>Case -19756 To -19752: pinyin = &quot;cang &quot;</p><p>Case -19751 To -19747: pinyin = &quot;cao &quot;</p><p>Case -19746 To -19742: pinyin = &quot;ce &quot;</p><p>Case -19741 To -19740: pinyin = &quot;ceng &quot;</p><p>Case -19739 To -19729: pinyin = &quot;cha &quot;</p><p>Case -19728 To -19726: pinyin = &quot;chai &quot;</p><p>Case -19725 To -19716: pinyin = &quot;chan &quot;</p><p>Case -19715 To -19541: pinyin = &quot;chang &quot;</p><p>Case -19540 To -19532: pinyin = &quot;chao &quot;</p><p>Case -19531 To -19526: pinyin = &quot;che &quot;</p><p>Case -19525 To -19516: pinyin = &quot;chen &quot;</p><p>Case -19515 To -19501: pinyin = &quot;cheng &quot;</p><p>Case -19500 To -19485: pinyin = &quot;chi &quot;</p><p>Case -19484 To -19480: pinyin = &quot;chong &quot;</p><p>Case -19479 To -19468: pinyin = &quot;chou &quot;</p><p>Case -19467 To -19290: pinyin = &quot;chu &quot;</p><p>Case -19289 To -19289: pinyin = &quot;chuai &quot;</p><p>Case -19288 To -19282: pinyin = &quot;chuan &quot;</p><p>Case -19281 To -19276: pinyin = &quot;chuang &quot;</p><p>Case -19275 To -19271: pinyin = &quot;chui &quot;</p><p>Case -19270 To -19264: pinyin = &quot;chun &quot;</p><p>Case -19263 To -19262: pinyin = &quot;chuo &quot;</p><p>Case -19261 To -19250: pinyin = &quot;ci &quot;</p><p>Case -19249 To -19244: pinyin = &quot;cong &quot;</p><p>Case -19243 To -19243: pinyin = &quot;cou &quot;</p><p>Case -19242 To -19239: pinyin = &quot;cu &quot;</p><p>Case -19238 To -19236: pinyin = &quot;cuan &quot;</p><p>Case -19235 To -19228: pinyin = &quot;cui &quot;</p><p>Case -19227 To -19225: pinyin = &quot;cun &quot;</p><p>Case -19224 To -19219: pinyin = &quot;cuo &quot;</p><p>Case -19218 To -19213: pinyin = &quot;da &quot;</p><p>Case -19212 To -19039: pinyin = &quot;dai &quot;</p><p>Case -19038 To -19024: pinyin = &quot;dan &quot;</p><p>Case -19023 To -19019: pinyin = &quot;dang &quot;</p><p>Case -19018 To -19007: pinyin = &quot;dao &quot;</p><p>Case -19006 To -19004: pinyin = &quot;de &quot;</p><p>Case -19003 To -18997: pinyin = &quot;deng &quot;</p><p>Case -18996 To -18978: pinyin = &quot;di &quot;</p><p>Case -18977 To -18962: pinyin = &quot;dian &quot;</p><p>Case -18961 To -18953: pinyin = &quot;diao &quot;</p><p>Case -18952 To -18784: pinyin = &quot;die &quot;</p><p>Case -18783 To -18775: pinyin = &quot;ding &quot;</p><p>Case -18774 To -18774: pinyin = &quot;diu &quot;</p><p>Case -18773 To -18527: pinyin = &quot;dong &quot;</p><p>Case -18526 To -18519: pinyin = &quot;fa &quot;</p><p>Case -18518 To -18502: pinyin = &quot;fan &quot;</p><p>Case -18501 To -18491: pinyin = &quot;fang &quot;</p><p>Case -18490 To -18479: pinyin = &quot;fei &quot;</p><p>Case -18478 To -18464: pinyin = &quot;fen &quot;</p><p>Case -18463 To -18449: pinyin = &quot;feng &quot;</p><p>Case -18448 To -18448: pinyin = &quot;fo &quot;</p><p>Case -18447 To -18447: pinyin = &quot;fou &quot;</p><p>Case -18446 To -18240: pinyin = &quot;fu &quot;</p><p>Case -18239 To -18238: pinyin = &quot;ga &quot;</p><p>Case -18237 To -18232: pinyin = &quot;gai &quot;</p><p>Case -18231 To -18221: pinyin = &quot;gan &quot;</p><p>Case -18220 To -18212: pinyin = &quot;gang &quot;</p><p>Case -18211 To -18202: pinyin = &quot;gao &quot;</p><p>Case -18201 To -18185: pinyin = &quot;ge &quot;</p><p>Case -18184 To -18184: pinyin = &quot;gei &quot;</p><p>Case -18183 To -18182: pinyin = &quot;gen &quot;</p><p>Case -18181 To -18013: pinyin = &quot;geng &quot;</p><p>Case -18012 To -17998: pinyin = &quot;gong &quot;</p><p>Case -17997 To -17989: pinyin = &quot;gou &quot;</p><p>Case -17988 To -17971: pinyin = &quot;gu &quot;</p><p>Case -17970 To -17965: pinyin = &quot;gua &quot;</p><p>Case -17964 To -17962: pinyin = &quot;guai &quot;</p><p>Case -17961 To -17951: pinyin = &quot;guan &quot;</p><p>Case -17950 To -17948: pinyin = &quot;guang &quot;</p><p>Case -17947 To -17932: pinyin = &quot;gui &quot;</p><p>Case -17931 To -17929: pinyin = &quot;gun &quot;</p><p>Case -17928 To -17923: pinyin = &quot;guo &quot;</p><p>Case -17922 To -17760: pinyin = &quot;ha &quot;</p><p>Case -17759 To -17753: pinyin = &quot;hai &quot;</p><p>Case -17752 To -17734: pinyin = &quot;han &quot;</p><p>Case -17733 To -17731: pinyin = &quot;hang &quot;</p><p>Case -17730 To -17722: pinyin = &quot;hao &quot;</p><p>Case -17721 To -17704: pinyin = &quot;he &quot;</p><p>Case -17703 To -17702: pinyin = &quot;hei &quot;</p><p>Case -17701 To -17698: pinyin = &quot;hen &quot;</p><p>Case -17697 To -17693: pinyin = &quot;heng &quot;</p><p>Case -17692 To -17684: pinyin = &quot;hong &quot;</p><p>Case -17683 To -17677: pinyin = &quot;hou &quot;</p><p>Case -17676 To -17497: pinyin = &quot;hu &quot;</p><p>Case -17496 To -17488: pinyin = &quot;hua &quot;</p><p>Case -17487 To -17483: pinyin = &quot;huai &quot;</p><p>Case -17482 To -17469: pinyin = &quot;huan &quot;</p><p>Case -17468 To -17455: pinyin = &quot;huang &quot;</p><p>Case -17454 To -17434: pinyin = &quot;hui &quot;</p><p>Case -17433 To -17428: pinyin = &quot;hun &quot;</p><p>Case -17427 To -17418: pinyin = &quot;huo &quot;</p><p>Case -17417 To -17203: pinyin = &quot;ji &quot;</p><p>Case -17202 To -17186: pinyin = &quot;jia &quot;</p><p>Case -17185 To -16984: pinyin = &quot;jian &quot;</p><p>Case -16983 To -16971: pinyin = &quot;jiang &quot;</p><p>Case -16970 To -16943: pinyin = &quot;jiao &quot;</p><p>Case -16942 To -16916: pinyin = &quot;jie &quot;</p><p>Case -16915 To -16734: pinyin = &quot;jin &quot;</p><p>Case -16733 To -16709: pinyin = &quot;jing &quot;</p><p>Case -16708 To -16707: pinyin = &quot;jiong &quot;</p><p>Case -16706 To -16690: pinyin = &quot;jiu &quot;</p><p>Case -16689 To -16665: pinyin = &quot;ju &quot;</p><p>Case -16664 To -16658: pinyin = &quot;juan &quot;</p><p>Case -16657 To -16648: pinyin = &quot;jue &quot;</p><p>Case -16647 To -16475: pinyin = &quot;jun &quot;</p><p>Case -16474 To -16471: pinyin = &quot;ka &quot;</p><p>Case -16470 To -16466: pinyin = &quot;kai &quot;</p><p>Case -16465 To -16460: pinyin = &quot;kan &quot;</p><p>Case -16459 To -16453: pinyin = &quot;kang &quot;</p><p>Case -16452 To -16449: pinyin = &quot;kao &quot;</p><p>Case -16448 To -16434: pinyin = &quot;ke &quot;</p><p>Case -16433 To -16430: pinyin = &quot;ken &quot;</p><p>Case -16429 To -16428: pinyin = &quot;keng &quot;</p><p>Case -16427 To -16424: pinyin = &quot;kong &quot;</p><p>Case -16423 To -16420: pinyin = &quot;kou &quot;</p><p>Case -16419 To -16413: pinyin = &quot;ku &quot;</p><p>Case -16412 To -16408: pinyin = &quot;kua &quot;</p><p>Case -16407 To -16404: pinyin = &quot;kuai &quot;</p><p>Case -16403 To -16402: pinyin = &quot;kuan &quot;</p><p>Case -16401 To -16394: pinyin = &quot;kuang &quot;</p><p>Case -16393 To -16221: pinyin = &quot;kui &quot;</p><p>Case -16220 To -16217: pinyin = &quot;kun &quot;</p><p>Case -16216 To -16213: pinyin = &quot;kuo &quot;</p><p>Case -16212 To -16206: pinyin = &quot;la &quot;</p><p>Case -16205 To -16203: pinyin = &quot;lai &quot;</p><p>Case -16202 To -16188: pinyin = &quot;lan &quot;</p><p>Case -16187 To -16181: pinyin = &quot;lang &quot;</p><p>Case -16180 To -16172: pinyin = &quot;lao &quot;</p><p>Case -16171 To -16170: pinyin = &quot;le &quot;</p><p>Case -16169 To -16159: pinyin = &quot;lei &quot;</p><p>Case -16158 To -16156: pinyin = &quot;leng &quot;</p><p>Case -16155 To -15960: pinyin = &quot;li &quot;</p><p>Case -15959 To -15959: pinyin = &quot;lia &quot;</p><p>Case -15958 To -15945: pinyin = &quot;lian &quot;</p><p>Case -15944 To -15934: pinyin = &quot;liang &quot;</p><p>Case -15933 To -15921: pinyin = &quot;liao &quot;</p><p>Case -15920 To -15916: pinyin = &quot;lie &quot;</p><p>Case -15915 To -15904: pinyin = &quot;lin &quot;</p><p>Case -15903 To -15890: pinyin = &quot;ling &quot;</p><p>Case -15889 To -15879: pinyin = &quot;liu &quot;</p><p>Case -15878 To -15708: pinyin = &quot;long &quot;</p><p>Case -15707 To -15702: pinyin = &quot;lou &quot;</p><p>Case -15701 To -15682: pinyin = &quot;lu &quot;</p><p>Case -15681 To -15668: pinyin = &quot;lv &quot;</p><p>Case -15667 To -15662: pinyin = &quot;luan &quot;</p><p>Case -15661 To -15660: pinyin = &quot;lue &quot;</p><p>Case -15659 To -15653: pinyin = &quot;lun &quot;</p><p>Case -15652 To -15641: pinyin = &quot;luo &quot;</p><p>Case -15640 To -15632: pinyin = &quot;ma &quot;</p><p>Case -15631 To -15626: pinyin = &quot;mai &quot;</p><p>Case -15625 To -15455: pinyin = &quot;man &quot;</p><p>Case -15454 To -15449: pinyin = &quot;mang &quot;</p><p>Case -15448 To -15437: pinyin = &quot;mao &quot;</p><p>Case -15436 To -15436: pinyin = &quot;me &quot;</p><p>Case -15435 To -15420: pinyin = &quot;mei &quot;</p><p>Case -15419 To -15417: pinyin = &quot;men &quot;</p><p>Case -15416 To -15409: pinyin = &quot;meng &quot;</p><p>Case -15408 To -15395: pinyin = &quot;mi &quot;</p><p>Case -15394 To -15386: pinyin = &quot;mian &quot;</p><p>Case -15385 To -15378: pinyin = &quot;miao &quot;</p><p>Case -15377 To -15376: pinyin = &quot;mie &quot;</p><p>Case -15375 To -15370: pinyin = &quot;min &quot;</p><p>Case -15369 To -15364: pinyin = &quot;ming &quot;</p><p>Case -15363 To -15363: pinyin = &quot;miu &quot;</p><p>Case -15362 To -15184: pinyin = &quot;mo &quot;</p><p>Case -15183 To -15181: pinyin = &quot;mou &quot;</p><p>Case -15180 To -15166: pinyin = &quot;mu &quot;</p><p>Case -15165 To -15159: pinyin = &quot;na &quot;</p><p>Case -15158 To -15154: pinyin = &quot;nai &quot;</p><p>Case -15153 To -15151: pinyin = &quot;nan &quot;</p><p>Case -15150 To -15150: pinyin = &quot;nang &quot;</p><p>Case -15149 To -15145: pinyin = &quot;nao &quot;</p><p>Case -15144 To -15144: pinyin = &quot;ne &quot;</p><p>Case -15143 To -15142: pinyin = &quot;nei &quot;</p><p>Case -15141 To -15141: pinyin = &quot;nen &quot;</p><p>Case -15140 To -15140: pinyin = &quot;neng &quot;</p><p>Case -15139 To -15129: pinyin = &quot;ni &quot;</p><p>Case -15128 To -15122: pinyin = &quot;nian &quot;</p><p>Case -15121 To -15120: pinyin = &quot;niang &quot;</p><p>Case -15119 To -15118: pinyin = &quot;niao &quot;</p><p>Case -15117 To -15111: pinyin = &quot;nie &quot;</p><p>Case -15110 To -15110: pinyin = &quot;nin &quot;</p><p>Case -15109 To -14942: pinyin = &quot;ning &quot;</p><p>Case -14941 To -14938: pinyin = &quot;niu &quot;</p><p>Case -14937 To -14934: pinyin = &quot;nong &quot;</p><p>Case -14933 To -14931: pinyin = &quot;nu &quot;</p><p>Case -14930 To -14930: pinyin = &quot;nv &quot;</p><p>Case -14929 To -14929: pinyin = &quot;nuan &quot;</p><p>Case -14928 To -14927: pinyin = &quot;nue &quot;</p><p>Case -14926 To -14923: pinyin = &quot;nuo &quot;</p><p>Case -14922 To -14922: pinyin = &quot;o &quot;</p><p>Case -14921 To -14915: pinyin = &quot;ou &quot;</p><p>Case -14914 To -14909: pinyin = &quot;pa &quot;</p><p>Case -14908 To -14903: pinyin = &quot;pai &quot;</p><p>Case -14902 To -14895: pinyin = &quot;pan &quot;</p><p>Case -14894 To -14890: pinyin = &quot;pang &quot;</p><p>Case -14889 To -14883: pinyin = &quot;pao &quot;</p><p>Case -14882 To -14874: pinyin = &quot;pei &quot;</p><p>Case -14873 To -14872: pinyin = &quot;pen &quot;</p><p>Case -14871 To -14858: pinyin = &quot;peng &quot;</p><p>Case -14857 To -14679: pinyin = &quot;pi &quot;</p><p>Case -14678 To -14675: pinyin = &quot;pian &quot;</p><p>Case -14674 To -14671: pinyin = &quot;piao &quot;</p><p>Case -14670 To -14669: pinyin = &quot;pie &quot;</p><p>Case -14668 To -14664: pinyin = &quot;pin &quot;</p><p>Case -14663 To -14655: pinyin = &quot;ping &quot;</p><p>Case -14654 To -14646: pinyin = &quot;po &quot;</p><p>Case -14645 To -14631: pinyin = &quot;pu &quot;</p><p>Case -14630 To -14595: pinyin = &quot;qi &quot;</p><p>Case -14594 To -14430: pinyin = &quot;qia &quot;</p><p>Case -14429 To -14408: pinyin = &quot;qian &quot;</p><p>Case -14407 To -14400: pinyin = &quot;qiang &quot;</p><p>Case -14399 To -14385: pinyin = &quot;qiao &quot;</p><p>Case -14384 To -14380: pinyin = &quot;qie &quot;</p><p>Case -14379 To -14369: pinyin = &quot;qin &quot;</p><p>Case -14368 To -14356: pinyin = &quot;qing &quot;</p><p>Case -14355 To -14354: pinyin = &quot;qiong &quot;</p><p>Case -14353 To -14346: pinyin = &quot;qiu &quot;</p><p>Case -14345 To -14171: pinyin = &quot;qu &quot;</p><p>Case -14170 To -14160: pinyin = &quot;quan &quot;</p><p>Case -14159 To -14152: pinyin = &quot;que &quot;</p><p>Case -14151 To -14150: pinyin = &quot;qun &quot;</p><p>Case -14149 To -14146: pinyin = &quot;ran &quot;</p><p>Case -14145 To -14141: pinyin = &quot;rang &quot;</p><p>Case -14140 To -14138: pinyin = &quot;rao &quot;</p><p>Case -14137 To -14136: pinyin = &quot;re &quot;</p><p>Case -14135 To -14126: pinyin = &quot;ren &quot;</p><p>Case -14125 To -14124: pinyin = &quot;reng &quot;</p><p>Case -14123 To -14123: pinyin = &quot;ri &quot;</p><p>Case -14122 To -14113: pinyin = &quot;rong &quot;</p><p>Case -14112 To -14110: pinyin = &quot;rou &quot;</p><p>Case -14109 To -14100: pinyin = &quot;ru &quot;</p><p>Case -14099 To -14098: pinyin = &quot;ruan &quot;</p><p>Case -14097 To -14095: pinyin = &quot;rui &quot;</p><p>Case -14094 To -14093: pinyin = &quot;run &quot;</p><p>Case -14092 To -14091: pinyin = &quot;ruo &quot;</p><p>Case -14090 To -14088: pinyin = &quot;sa &quot;</p><p>Case -14087 To -14084: pinyin = &quot;sai &quot;</p><p>Case -14083 To -13918: pinyin = &quot;san &quot;</p><p>Case -13917 To -13915: pinyin = &quot;sang &quot;</p><p>Case -13914 To -13911: pinyin = &quot;sao &quot;</p><p>Case -13910 To -13908: pinyin = &quot;se &quot;</p><p>Case -13907 To -13907: pinyin = &quot;sen &quot;</p><p>Case -13906 To -13906: pinyin = &quot;seng &quot;</p><p>Case -13905 To -13897: pinyin = &quot;sha &quot;</p><p>Case -13896 To -13895: pinyin = &quot;shai &quot;</p><p>Case -13894 To -13879: pinyin = &quot;shan &quot;</p><p>Case -13878 To -13871: pinyin = &quot;shang &quot;</p><p>Case -13870 To -13860: pinyin = &quot;shao &quot;</p><p>Case -13859 To -13848: pinyin = &quot;she &quot;</p><p>Case -13847 To -13832: pinyin = &quot;shen &quot;</p><p>Case -13831 To -13659: pinyin = &quot;sheng &quot;</p><p>Case -13658 To -13612: pinyin = &quot;shi &quot;</p><p>Case -13611 To -13602: pinyin = &quot;shou &quot;</p><p>Case -13601 To -13407: pinyin = &quot;shu &quot;</p><p>Case -13406 To -13405: pinyin = &quot;shua &quot;</p><p>Case -13404 To -13401: pinyin = &quot;shuai &quot;</p><p>Case -13400 To -13399: pinyin = &quot;shuan &quot;</p><p>Case -13398 To -13396: pinyin = &quot;shuang &quot;</p><p>Case -13395 To -13392: pinyin = &quot;shui &quot;</p><p>Case -13391 To -13388: pinyin = &quot;shun &quot;</p><p>Case -13387 To -13384: pinyin = &quot;shuo &quot;</p><p>Case -13383 To -13368: pinyin = &quot;si &quot;</p><p>Case -13367 To -13360: pinyin = &quot;song &quot;</p><p>Case -13359 To -13357: pinyin = &quot;sou &quot;</p><p>Case -13356 To -13344: pinyin = &quot;su &quot;</p><p>Case -13343 To -13341: pinyin = &quot;suan &quot;</p><p>Case -13340 To -13330: pinyin = &quot;sui &quot;</p><p>Case -13329 To -13327: pinyin = &quot;sun &quot;</p><p>Case -13326 To -13319: pinyin = &quot;suo &quot;</p><p>Case -13318 To -13148: pinyin = &quot;ta &quot;</p><p>Case -13147 To -13139: pinyin = &quot;tai &quot;</p><p>Case -13138 To -13121: pinyin = &quot;tan &quot;</p><p>Case -13120 To -13108: pinyin = &quot;tang &quot;</p><p>Case -13107 To -13097: pinyin = &quot;tao &quot;</p><p>Case -13096 To -13096: pinyin = &quot;te &quot;</p><p>Case -13095 To -13092: pinyin = &quot;teng &quot;</p><p>Case -13091 To -13077: pinyin = &quot;ti &quot;</p><p>Case -13076 To -13069: pinyin = &quot;tian &quot;</p><p>Case -13068 To -13064: pinyin = &quot;tiao &quot;</p><p>Case -13063 To -13061: pinyin = &quot;tie &quot;</p><p>Case -13060 To -12889: pinyin = &quot;ting &quot;</p><p>Case -12888 To -12876: pinyin = &quot;tong &quot;</p><p>Case -12875 To -12872: pinyin = &quot;tou &quot;</p><p>Case -12871 To -12861: pinyin = &quot;tu &quot;</p><p>Case -12860 To -12859: pinyin = &quot;tuan &quot;</p><p>Case -12858 To -12853: pinyin = &quot;tui &quot;</p><p>Case -12852 To -12850: pinyin = &quot;tun &quot;</p><p>Case -12849 To -12839: pinyin = &quot;tuo &quot;</p><p>Case -12838 To -12832: pinyin = &quot;wa &quot;</p><p>Case -12831 To -12830: pinyin = &quot;wai &quot;</p><p>Case -12829 To -12813: pinyin = &quot;wan &quot;</p><p>Case -12812 To -12803: pinyin = &quot;wang &quot;</p><p>Case -12802 To -12608: pinyin = &quot;wei &quot;</p><p>Case -12607 To -12598: pinyin = &quot;wen &quot;</p><p>Case -12597 To -12595: pinyin = &quot;weng &quot;</p><p>Case -12594 To -12586: pinyin = &quot;wo &quot;</p><p>Case -12585 To -12557: pinyin = &quot;wu &quot;</p><p>Case -12556 To -12360: pinyin = &quot;xi &quot;</p><p>Case -12359 To -12347: pinyin = &quot;xia &quot;</p><p>Case -12346 To -12321: pinyin = &quot;xian &quot;</p><p>Case -12320 To -12301: pinyin = &quot;xiang &quot;</p><p>Case -12300 To -12121: pinyin = &quot;xiao &quot;</p><p>Case -12120 To -12100: pinyin = &quot;xie &quot;</p><p>Case -12099 To -12090: pinyin = &quot;xin &quot;</p><p>Case -12089 To -12075: pinyin = &quot;xing &quot;</p><p>Case -12074 To -12068: pinyin = &quot;xiong &quot;</p><p>Case -12067 To -12059: pinyin = &quot;xiu &quot;</p><p>Case -12058 To -12040: pinyin = &quot;xu &quot;</p><p>Case -12039 To -11868: pinyin = &quot;xuan &quot;</p><p>Case -11867 To -11862: pinyin = &quot;xue &quot;</p><p>Case -11861 To -11848: pinyin = &quot;xun &quot;</p><p>Case -11847 To -11832: pinyin = &quot;ya &quot;</p><p>Case -11831 To -11799: pinyin = &quot;yan &quot;</p><p>Case -11798 To -11782: pinyin = &quot;yang &quot;</p><p>Case -11781 To -11605: pinyin = &quot;yao &quot;</p><p>Case -11604 To -11590: pinyin = &quot;ye &quot;</p><p>Case -11589 To -11537: pinyin = &quot;yi &quot;</p><p>Case -11536 To -11359: pinyin = &quot;yin &quot;</p><p>Case -11358 To -11341: pinyin = &quot;ying &quot;</p><p>Case -11340 To -11340: pinyin = &quot;yo &quot;</p><p>Case -11339 To -11325: pinyin = &quot;yong &quot;</p><p>Case -11324 To -11304: pinyin = &quot;you &quot;</p><p>Case -11303 To -11098: pinyin = &quot;yu &quot;</p><p>Case -11097 To -11078: pinyin = &quot;yuan &quot;</p><p>Case -11077 To -11068: pinyin = &quot;yue &quot;</p><p>Case -11067 To -11056: pinyin = &quot;yun &quot;</p><p>Case -11055 To -11053: pinyin = &quot;za &quot;</p><p>Case -11052 To -11046: pinyin = &quot;zai &quot;</p><p>Case -11045 To -11042: pinyin = &quot;zan &quot;</p><p>Case -11041 To -11039: pinyin = &quot;zang &quot;</p><p>Case -11038 To -11025: pinyin = &quot;zao &quot;</p><p>Case -11024 To -11021: pinyin = &quot;ze &quot;</p><p>Case -11020 To -11020: pinyin = &quot;zei &quot;</p><p>Case -11019 To -11019: pinyin = &quot;zen &quot;</p><p>Case -11018 To -11015: pinyin = &quot;zeng &quot;</p><p>Case -11014 To -10839: pinyin = &quot;zha &quot;</p><p>Case -10838 To -10833: pinyin = &quot;zhai &quot;</p><p>Case -10832 To -10816: pinyin = &quot;zhan &quot;</p><p>Case -10815 To -10801: pinyin = &quot;zhang &quot;</p><p>Case -10800 To -10791: pinyin = &quot;zhao &quot;</p><p>Case -10790 To -10781: pinyin = &quot;zhe &quot;</p><p>Case -10780 To -10765: pinyin = &quot;zhen &quot;</p><p>Case -10764 To -10588: pinyin = &quot;zheng &quot;</p><p>Case -10587 To -10545: pinyin = &quot;zhi &quot;</p><p>Case -10544 To -10534: pinyin = &quot;zhong &quot;</p><p>Case -10533 To -10520: pinyin = &quot;zhou &quot;</p><p>Case -10519 To -10332: pinyin = &quot;zhu &quot;</p><p>Case -10331 To -10330: pinyin = &quot;zhua &quot;</p><p>Case -10329 To -10329: pinyin = &quot;zhuai &quot;</p><p>Case -10328 To -10323: pinyin = &quot;zhuan &quot;</p><p>Case -10322 To -10316: pinyin = &quot;zhuang &quot;</p><p>Case -10315 To -10310: pinyin = &quot;zhui &quot;</p><p>Case -10309 To -10308: pinyin = &quot;zhun &quot;</p><p>Case -10307 To -10297: pinyin = &quot;zhuo &quot;</p><p>Case -10296 To -10282: pinyin = &quot;zi &quot;</p><p>Case -10281 To -10275: pinyin = &quot;zong &quot;</p><p>Case -10274 To -10271: pinyin = &quot;zou &quot;</p><p>Case -10270 To -10263: pinyin = &quot;zu &quot;</p><p>Case -10262 To -10261: pinyin = &quot;zuan &quot;</p><p>Case -10260 To -10257: pinyin = &quot;zui &quot;</p><p>Case -10256 To -10255: pinyin = &quot;zun &quot;</p><p>Case -10254 To -10254: pinyin = &quot;zuo &quot;</p><p>Case Else: pinyin = p</p><p>End Select</p><p>End Function</p><p>Function getpy(str)</p><p>For i = 1 To Len(str)</p><p>getpy = getpy &amp; pinyin(Mid(str, i, 1))</p><p>Next i</p><p>End Function</p><p><br/></p><p>保存,关闭Visual Basic编辑窗口并返回Excel编辑状态。</p><p>选中转换后的拼音需要放在哪个列,例如放在D列的第2个单元格,输入公式:=getpy(A1)</p><p><img title="1.jpg" alt="1.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/07/20180709155905_17928.jpg"/></p><p>如果出现个别汉字不能转换,手动删除汉字,输入拼音就可以了。</p><p>去除拼音之间的空格。去掉空格的拼音放在E列,如果这个数据原来在B2单元格,去掉空格之后的拼音放在E2单元格,则在E2单元格输入: =SUBSTITUTE(B2,&quot; &quot;,&quot;&quot;)</p><p><img title="22.jpg" alt="22.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/07/20180709160222_20567.jpg"/></p><p><br/></p><p>备注:此方法只能遇到需要使用此功能的表格,就需要使用此次方法</p></div><p></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/software/model.html" target="_blank">继续阅读《excel中把汉字转换成拼音》的全文内容...</a></p><p>分类: 软件技巧 | Tags: <a href="http://www.pmohcs.tw/tag/excel">excel</a>,<a href="http://www.pmohcs.tw/tag/%E6%A8%A1%E5%9D%97">模块</a>, | <a href="http://www.pmohcs.tw/software/model.html#comment" target="_blank">添加评论</a>(3)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/software/model.html#comment-246">2018-09-10 23:29:42 PM</a>,头条 : 文章不错非常?#19981;?lt;/li><li><a href="http://www.pmohcs.tw/software/model.html#comment-247">2018-10-12 10:48:18 AM</a>,江苏grc : 原来还可以这样</li><li><a href="http://www.pmohcs.tw/software/model.html#comment-249">2018-10-19 15:41:55 PM</a>,hebl : ?#34892;?#20998;享 hebl@182hjs.cc</li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/software/excel1.html">EXCEL常用技巧1</a> (2017-09-29) </li><li><a href="http://www.pmohcs.tw/software/pano2vr.html">打开swf提示pano2vr许可证过期(pano2vr trial license expired)</a> (2016-07-06) </li><li><a href="http://www.pmohcs.tw/software/foxmail.html">foxmail不能发邮件和回?#20174;?#20214;,窗口切不过来</a> (2017-07-25) </li><li><a href="http://www.pmohcs.tw/software/chrome20170601.html">新版chrome浏览器搜索不能显示汉字的解决办法</a> (2017-06-01) </li><li><a href="http://www.pmohcs.tw/software/MSXML0629.html">win7下安装Office2010老是出现提示安装MSXML6.10.1129.0,下载官方MSXML6</a> (2016-06-29) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Mon, 09 Jul 2018 14:43:09 +0800 安装软件出现缺少vcruntime140dll的解决方法http://www.pmohcs.tw/diannaojiqiao/vcruntime140.html<p>&nbsp;</p><p>首先下载vc++2015,注意自己系统是32?#25442;?#26159;64位的,下载对应版本。然后进行安装。</p><p>如果只出现了修复按钮,那说明你已经安装过了,点击修复。</p><p>这里提供 64位的vc++2015,32位的请自行百?#21462;?2位vc++2015”</p><p>链接: http://pan.baidu.com/s/1pLaRTRd 密码: un85</p><p>&nbsp;</p><p>到这里,对于32位的系统已经完成了vcruntime140.dll的修复工作,可以重新安装软件了。</p><p><strong>vcruntime140.dll 64位控件常规安装方法(仅供参考):</strong></p><p>首先,下载vcruntime140.dll(或者互联网百度下)</p><p>链接: http://pan.baidu.com/s/1mi1wy3A 密码: r7n3</p><p><br/></p><p><strong><img width="390" height="146" title="333333.jpg" style="width: 356px; height: 172px;" alt="333333.jpg" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/05/20180510131053_83955.jpg"/></strong></p><p>一、如果在运行某软件或编译程序时提示缺少、找不到vcruntime140.dll 64位等类似提示,您可将从下载来的vcruntime140.dll 64位拷贝到指定目?#25216;?#21487;(一般是system系统目录或放到软件同级目录里面),或者重新添加文件引用。 <br/> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;二、然后根据您系?#36710;?#24773;况选择X86/X64,X86为32位电脑,X64为64位电脑。默认都是支持32位系?#36710;模?如果您不知道是X86还是X64。 <br/> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;三、根据软件情况选择文件版本。此步骤比较复杂,如果是Windows的dll文件,&nbsp;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;版本号以5.1开头的或含有 xp、xpsp1、xpsp2、xpsp3 信息的一般是windowsXP的文件。 <br/> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;     &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;版本号以6.0开头的或含有 longhorn、vista 信息的一般是windowsVista的文件。 <br/> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;     &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;版本号以6.1开头的或含有 win7 信息的一般是windows7的文件。 如果不是windows的dll文件,则需要灵活查看版本号、描述提供的信息、以及相关dll的版本号去?#21368;稀?<br/> 四、直接拷贝该文件到系统目录里:<br/>1、Windows XP/WIN7/win10系统(64位系统对应64位dll文件,32位系统对应32位dll文件),将vcruntime140.dll &nbsp;64位?#31895;?#21040;C:\Windows\System32目录下。<br/>2、<span style="color: red;">如果您的系统是64位的请将32位的dll文件?#31895;?#21040;C:\Windows\SysWOW64目录</span>,:win7 64位旗舰版系统运行regsvr32.exe提示版本不兼容<br/> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;五、打开&quot;开始-运行-输入regsvr32 vcruntime140.dll 64位&quot;,回车即可解决。</p><p>通过脚本之家下载dll的朋友,可将下面的代码保存为“注册64位.bat“,放到dll文件同级目录(只要在同一个文件夹里面有这两个文件即可),双击“注册64位.bat?#20445;?#23601;会自动完成vcruntime140.dll 64位注册。<br/><strong>下面是系统与dll版本对应的注册bat文件(64位的系统对应64位dll文件,32位系统对应32位的dll文件,如果64位的系统安装32位的dll文件,请将下面的system32替换为SysWOW64即可。)</strong></p><p><br/></p><pre class="prism-highlight prism-language-basic">&nbsp;@echo&nbsp;开始注册 copy&nbsp;vcruntime140.dll&nbsp;64位&nbsp;%windir%\system32\ &nbsp;regsvr32&nbsp;%windir%\system32\vcruntime140.dll&nbsp;64位&nbsp;/s &nbsp;@echo&nbsp;vcruntime140.dll&nbsp;64位注册成功 @pause</pre><p><br/></p><p>文章综合分享自互联网</p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/diannaojiqiao/vcruntime140.html" target="_blank">继续阅读《安装软件出现缺少vcruntime140dll的解决方法》的全文内容...</a></p><p>分类: 技巧知识 | Tags: <a href="http://www.pmohcs.tw/tag/%E7%B3%BB%E7%BB%9F">系统</a>, | <a href="http://www.pmohcs.tw/diannaojiqiao/vcruntime140.html#comment" target="_blank">添加评论</a>(2)</p><hr /> <h3>最新评论:</h3><ul><li><a href="http://www.pmohcs.tw/diannaojiqiao/vcruntime140.html#comment-242">2018-06-07 16:58:05 PM</a>,好特易购 : 用胶水就用可赛新胶水和乐泰胶水这才是正确的选择 https:www.hyhaote.com</li><li><a href="http://www.pmohcs.tw/diannaojiqiao/vcruntime140.html#comment-255">2018-12-14 10:13:27 AM</a>,江苏GRC构件 : 技术文章,值得收藏</li></ul><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/diannaojiqiao/quanpin.html">win7的系统_玩CF的时候不能全屏</a> (2014-07-10) </li><li><a href="http://www.pmohcs.tw/system/1013-windows10.html">Windows10降级教程:降至Win7/Win8.1</a> (2016-10-13) </li><li><a href="http://www.pmohcs.tw/system/qingli.html">Win7清理系统垃圾文件脚本</a> (2017-04-20) </li><li><a href="http://www.pmohcs.tw/system/peizhi20170329.html">开机输入密码提示无法加载用户配置文件</a> (2017-03-29) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Fri, 01 Jun 2018 13:01:59 +0800 win10更新提示错误0x80070422解决方法http://www.pmohcs.tw/diannaojiqiao/windows-update.html<p>&nbsp;win10更新时候,提示安装更新出现一些问题,错误代码0x80070422</p><p>设置---更新与安全---Windows更新--点击?#26477;?#26597;更新</p><p>然后提示 错误代码0x80070422</p><p><img width="595" height="222" title="0000.jpg" style="width: 258px; height: 152px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/05/20180528110001_17091.jpg"/></p><p>问题原因:</p><p>windows update 启动类型变成禁止更新(可能是安全软件或者手动禁用的)。,</p><p>解决:</p><p>1,先找到是否是360安全卫士,联想安全管家,腾讯管家等软件上手动关闭Windows update,找到并打开。</p><p>2,在设置列表中,找到Window系?#36710;脑?#34892;(WIN+R),点击它,输入services.msc&nbsp;&nbsp;,打开服务后,找到Windows UPDATE 服务,看下是不是禁用状态!改成自动就行了!</p><p><br/></p><p><img width="1002" height="554" title="1.jpg" style="width: 543px; height: 398px;" src="http://myzblog.oss-cn-beijing.aliyuncs.com/myzblog/upload/2018/05/20180528110001_36784.jpg"/></p><p><br/></p><p><br/></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.pmohcs.tw/diannaojiqiao/windows-update.html" target="_blank">继续阅读《win10更新提示错误0x80070422解决方法》的全文内容...</a></p><p>分类: 技巧知识 | Tags: <a href="http://www.pmohcs.tw/tag/win10">win10</a>, | <a href="http://www.pmohcs.tw/diannaojiqiao/windows-update.html#comment" target="_blank">添加评论</a>(0)</p><p><a href="http://www.pmohcs.tw/diannaojiqiao/windows-update.html#comment" target="_blank">还没有评论,您?#27492;?#20004;句?</a></p><h3>相关文章:</h3><ul><li><a href="http://www.pmohcs.tw/system/UEFIBOIS1603.html">预装win8/10系?#36710;?#26032;型主板的新机器无法安装win7的问题</a> (2016-03-16) </li></ul><a target="_blank" title="長大樂忧伤" href="http://www.pmohcs.tw/"><img alt="Z-Blog" src="http://www.pmohcs.tw/zb_system/image/admin/none.gif"></a>Fri, 01 Jun 2018 10:57:30 +0800 足球比分007网址