快乐十分开奖结查询天津http://www.nsbxbd.tw/大向微博客-長大樂憂傷www.nsbxbd.tw 有自主權的域名根服務器http://www.nsbxbd.tw/news/cnnic.html<p><span class="bjh-p">&nbsp;&nbsp;&nbsp;&nbsp;根服務器主要用來管理互聯網的主目錄,全世界IPv4根服務器只有13臺(這13臺IPv4根域名服務器名字分別為“A”至“M”),1個為主根服務器在美國。其余12個均為輔根服務器,其中9個在美國,歐洲2個,位于英國和瑞典,亞洲1個位于日本。<br/>&nbsp;&nbsp;&nbsp;&nbsp;在與現有IPv4根服務器體系架構充分兼容基礎上,中國主導“雪人計劃”于2016年在全球16個國家完成25臺IPv6根服務器架設,事實上形成了13臺原有根加25臺IPv6根的新格局,為建立多邊、民主、透明的國際互聯網治理體系打下堅實基礎。中國部署了其中的4臺,由1臺主根服務器和3臺輔根服務器組成,打破了中國過去沒有根服務器的困境。<br/>根域名服務器是架構因特網所必須的基礎設施。在國外,許多計算機科學家將根域名服務器稱作“真理”(TRUTH),足見其重要性。換句話說——攻擊整個因特網最有力、最直接,也是最致命的方法恐怕就是攻擊根域名服務器了。<br/></span></p><p><span class="bjh-p">2019年6月</span><span class="bjh-p">26日,工信部同意中國互聯網絡信息中心設立域名根服務器及運行機構。工信部同意中國互聯網絡信息中心(CNNIC)設立域</span><span class="bjh-p">名根服務器(F、I、K、L根鏡像服務器)及域名根服務器運行機構,負責運行、維護和管理編號分別為JX0001F、JX0002F、JX0003I、JX0004K、JX0005L、JX0006L的域名根服務器。、</span></p><p><span class="bjh-p">下為工信部批復全文:</span></p><blockquote style="font: 14px/23.8px 宋體; text-align: left; color: rgb(0, 0, 0); text-transform: none; text-indent: 0px; letter-spacing: normal; word-spacing: 0px; white-space: normal; widows: 1; font-size-adjust: none; font-stretch: normal; background-color: rgb(255, 255, 255); -webkit-text-stroke-width: 0px;"><p style="font-family: 宋體;">  發文機關: 工業和信息化部</p><p style="font-family: 宋體;">  標  題:工業和信息化部關于同意中國互聯網絡信息中心設立域名根服務器(F、I、K、L根鏡像服務器)及域名根服務器運行機構的批復</p><p style="font-family: 宋體;">  發文字號:工信部信管函〔2019〕172號</p><p style="font-family: 宋體;">  成文日期:2019-06-24</p><p style="font-family: 宋體;">  發布日期:2019-06-26</p><p style="font-family: 宋體;">  文章來源:信息通信管理局</p><p style="font-family: 宋體;">  分類:信息通信管理</p><p style="font-family: 宋體;">  工業和信息化部關于同意中國互聯網絡信息中心設立域名根服務器(F、I、K、L根鏡像服務器)及域名根服務器運行機構的批復</p><p style="font-family: 宋體;">  工信部信管函〔2019〕172號</p><p style="font-family: 宋體;">  中國互聯網絡信息中心:</p><p style="font-family: 宋體;">  你中心關于設立域名根服務器(F、I、K、L根鏡像服務器)及域名根服務器運行機構的申請收悉。根據《互聯網域名管理辦法》(工業和信息化部令第43號)有關規定,經審查,現批復如下:</p><p style="font-family: 宋體;">  一、同意你中心設立域名根服務器(F、I、K、L根鏡像服務器)及成為域名根服務器運行機構,負責運行、維護和管理編號分別為JX0001F、JX0002F、JX0003I、JX0004K、JX0005L、JX0006L的域名根服務器。</p><p style="font-family: 宋體;">  二、你中心應嚴格遵守《互聯網域名管理辦法》《通信網絡安全防護管理辦法》及相關法律法規、行政規章及行業管理規定,接受我部的管理和監督檢查,建立符合我部要求的信息管理系統并與我部指定的管理系統對接,保證域名根服務器安全、可靠運行,為用戶提供安全、方便的域名服務,保障服務質量,保護用戶個人信息安全,維護國家利益和用戶權益。</p><p style="font-family: 宋體;">  三、你中心應當制定并不斷完善域名根服務器及域名根服務器運行機構的管理制度;指定專門人員負責域名根服務器的運行、維護和管理工作,建立固定的聯系機制;選擇具備資質的網絡接入服務提供者為域名根服務器提供接入服務;域名根服務器機房地址、互聯網協議(IP)地址和自治域(AS)號碼等信息發生變更時,應當在變更之日前15日以書面形式報送我部。</p><p style="font-family: 宋體;">  四、你中心應配置必要的網絡資源以及網絡和通信應急設備,制定切實有效的網絡通信保障和網絡與信息安全應急預案,設立、配備專職網絡與信息安全管理機構和人員,建立健全網絡與信息安全制度與保障措施,建立相應的業務與安全管理系統,建設監測預警、應急處置、數據備份等必要的技術手段,定期報送信息,服從我部的統一指揮與協調,配合開展相關測試和演練,遵守相應的管理要求。</p><p style="font-family: 宋體;">  五、你中心應當在每季度結束后的5個工作日內將域名根服務器上一季度的業務開展情況、安全運行情況等信息報送我部(傳真:010-66037097;電子郵件:domain@miit.gov.cn)。</p><p style="font-family: 宋體;">  六、你中心在運行、維護和管理域名根服務器過程中遇到問題,需及時以書面形式報送我部。</p><p style="font-family: 宋體;">  七、此批復自發布之日起生效,有效期為5年。</p><p style="font-family: 宋體;">  此復。</p><p style="font-family: 宋體;">  工業和信息化部</p><p style="font-family: 宋體;">  2019年6月24日</p></blockquote><p>&nbsp;</p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.nsbxbd.tw/news/cnnic.html" target="_blank">繼續閱讀《有自主權的域名根服務器》的全文內容...</a></p><p>分類: 新聞資訊 | Tags: <a href="http://www.nsbxbd.tw/tag/cnnic">cnnic</a>, | <a href="http://www.nsbxbd.tw/news/cnnic.html#comment" target="_blank">添加評論</a>(0)</p><p><a href="http://www.nsbxbd.tw/news/cnnic.html#comment" target="_blank">還沒有評論,您來說兩句?</a></p><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/news/zaibo.html">TD-LTE載波聚合實現高速下載速率</a> (2014-09-04) </li><li><a href="http://www.nsbxbd.tw/news/20150201huaweiU900.html">華為U900廣覆蓋技術解決方案</a> (2015-02-01) </li><li><a href="http://www.nsbxbd.tw/news/20140910xidada.html">師者,所以傳道授業解惑也</a> (2014-09-10) </li><li><a href="http://www.nsbxbd.tw/news/66.html">美海軍司令部槍擊案造成13人死亡 2名槍手仍在逃</a> (2013-09-17) </li><li><a href="http://www.nsbxbd.tw/news/dianyuan.html">國家質檢總局提及5200毫安小米移動電源容量虛標現象</a> (2014-08-25) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Wed, 26 Jun 2019 14:25:46 +0800 強制卸載360企業版(360天擎)方法http://www.nsbxbd.tw/software/360tianqing.html<p>&nbsp;強制卸載360企業版(360天擎)方法</p><p>方法一:(推薦)</p><p>1,找到360天擎目錄 /360/360safe目錄下</p><p>找到4個文件 360EntCall.exe&nbsp;、360EntClient.exe、360EntClient.ini、360EntClient_update.ini</p><p>直接刪除,如果提示拒絕訪問或者無權限,可下載騰訊軟件管家工具里面的一個文件粉碎機進行粉碎。(經過實際測試可行,其他文件直接粉碎是粉碎不了的)</p><p>2,文件刪除或粉碎后。 在點擊<span style="color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: arial; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; background-color: #FFFFFF; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;"><span class="Apple-converted-space">&nbsp;</span>Uninst.exe 可直接卸載成功</span></p><p><span style="color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: arial; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; background-color: #FFFFFF; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">方法二:</span></p><p><span style="color: #333333; text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: arial; font-size: 13px; font-style: normal; font-weight: normal; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; background-color: #FFFFFF; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">如果可以進安全模式或者windowPE模式,可找到對應目錄直接刪除。</span></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.nsbxbd.tw/software/360tianqing.html" target="_blank">繼續閱讀《強制卸載360企業版(360天擎)方法》的全文內容...</a></p><p>分類: 軟件技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/360">360</a>, | <a href="http://www.nsbxbd.tw/software/360tianqing.html#comment" target="_blank">添加評論</a>(0)</p><p><a href="http://www.nsbxbd.tw/software/360tianqing.html#comment" target="_blank">還沒有評論,您來說兩句?</a></p><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/news/liebao.html">瀏覽器搶票大作戰 獵豹 360 12306</a> (2013-09-15) </li><li><a href="http://www.nsbxbd.tw/news/68.html">從360強制改默認搜狗瀏覽器,再看互聯網黑暗森林</a> (2013-09-21) </li><li><a href="http://www.nsbxbd.tw/news/87.html">泄露網民隱私阻礙行業創新 搜索引擎無視Robots協議三大危害 360請尊重robots的最后底線</a> (2013-10-19) </li><li><a href="http://www.nsbxbd.tw/news/76.html">因懷疑360誘導用戶卸載自身產品</a> (2013-09-28) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Wed, 15 May 2019 22:42:12 +0800 如何對含有回車的單元格進行分列?http://www.nsbxbd.tw/system/excel0409.html<p>[操作與技巧]</p><p>如何對含有回車的單元格進行分列?</p><p>&nbsp;需要將特定的符號(如逗號)全部替換成軟回車,網上找到以下方法,特此記錄以備用啦</p><p>  1.如果在整個工作表中進行查找和替換,單擊任何單元格取消選定的活動區域,不然只在活動區域進行,就有可能無法正確的找到數據。</p><p>  2.如果查找完整的單元格,需要選擇“編輯”→“查找”或“替換”,取消選擇“單元格匹配”,然后再重新搜索。</p><p>  3.如果要查找的數據是常數或者公式結果,就需要在“查找和替換”中的“查找范圍”下拉框中選為值。如果數據包含公式或單元格批注中,需要從“查找范圍”選擇“公式”或“批注”,才能準確找到需要的數據。</p><p>一、查找excel單元格中的換行符(alt + enter)<br/> 在excel中要批量查找軟回車(alt + enter)可以通過在查找框內(通過按ctrl + f調出)輸入:按住alt鍵不放,然后依次通過數字鍵盤輸入1和0兩個數字,放開數字鍵后再放開alt鍵。<br/> 注意:<br/>1、輸入以上按鍵時查找框內看不到變化,但沒關系,不要多輸,也不要輸少了;<br/>2、如果是用筆記本電腦,也不要用數字鍵輸入10,必須調用字母按鍵上的數字小鍵盤才行。</p><p>二、批量刪除或替換換行符(alt + enter)<br/> 知道怎么查找后,這個就容易了。<br/> 調出“查找和替換”框(可直接按ctrl + h調出),在查找內容框內按以上方法輸入,在替換內容框中輸入你要替換成的內容,如果不輸入內容則為刪除查找的內容。</p><p></p><p> ? Copyright ibolg.net 2010-2019.</p><p><a href="http://www.nsbxbd.tw/system/excel0409.html" target="_blank">繼續閱讀《如何對含有回車的單元格進行分列?》的全文內容...</a></p><p>分類: 操作系統技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/excel">excel</a>, | <a href="http://www.nsbxbd.tw/system/excel0409.html#comment" target="_blank">添加評論</a>(4)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/system/excel0409.html#comment-266">2019-04-18 15:40:51 PM</a>,日月賺 : 如果能配點圖 應該更好些</li><li><a href="http://www.nsbxbd.tw/system/excel0409.html#comment-267">2019-04-19 19:00:11 PM</a>,熱血學霸 : 好好學習,天天向上</li><li><a href="http://www.nsbxbd.tw/system/excel0409.html#comment-269">2019-05-07 15:30:18 PM</a>,文娛帝國 : 寫的很好,支持下</li><li><a href="http://www.nsbxbd.tw/system/excel0409.html#comment-270">2019-05-11 23:01:41 PM</a>,新聞頭條 : 文章不錯非常喜歡,支持</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/software/tongji20171031.html">Excel中周統計數據的技巧</a> (2017-10-31) </li><li><a href="http://www.nsbxbd.tw/software/model.html">excel中把漢字轉換成拼音</a> (2018-07-09) </li><li><a href="http://www.nsbxbd.tw/software/word20170310.html">word與EXCEL單元格鏈接更新時產生回車的解決</a> (2017-02-10) </li><li><a href="http://www.nsbxbd.tw/system/excel20161114.html">excel表格數據全部變成了日期格式</a> (2016-11-14) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Tue, 09 Apr 2019 20:04:40 +0800 解決電腦文件或文件夾右上角出現兩個箭頭http://www.nsbxbd.tw/system/arrow.html<p>&nbsp;桌面圖標右上角出現藍色箭頭,單個右鍵可去除,無法批量去除,新建文檔和文件夾時又會出現新的箭頭。<br/><br/>解決這個問題是分兩種情況:<br/><br/>一、解決桌面已經存在的某單個文件和文件夾或多個文件和文件夾出現兩個藍色對角箭頭:<br/>解決辦法:選擇單個文件和文件夾或多個文件和文件夾,點擊“屬性”,在“常規”選項卡中的屬于項中選擇“高級”,出現高級屬性對話框之后選擇“壓縮或加密屬性”取消“壓縮內容以便節省磁盤空間(C)”,點擊“確定”,返回“文件屬性”對話框,點“應用”再點擊“確定”。<br/>二、解決在桌面原來不存在,需要新建文件或文件夾時出現兩個藍色對角箭頭:<br/>解決辦法:雙擊“我的電腦”,選擇“C盤”,點擊“看查”/“選項”出現“文件夾選項”,選擇:“查看”取消“隱藏文件和文件夾”前的勾,選擇“顯示隱藏的文件、文件夾和驅動器”,點擊“確定”,現在在C盤下可以看到一個”用戶“文件夾,雙擊”用戶“,選擇現在正在使用的用戶名,例如Administrator,雙擊用戶名,找到該文件夾下的”桌面“或”Desktop“點擊“屬性”,在“常規”選項卡中的屬于項中選擇“高級”,出現高級屬性對話框之后選擇“壓縮或加密屬性”取消“壓縮內容以便節省磁盤空間(C)”,點擊“確定”,返回“文件屬性”對話框,點“應用”再點擊“確定”。<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.nsbxbd.tw/system/arrow.html" target="_blank">繼續閱讀《解決電腦文件或文件夾右上角出現兩個箭頭》的全文內容...</a></p><p>分類: 操作系統技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/%E7%94%B5%E8%84%91">電腦</a>, | <a href="http://www.nsbxbd.tw/system/arrow.html#comment" target="_blank">添加評論</a>(0)</p><p><a href="http://www.nsbxbd.tw/system/arrow.html#comment" target="_blank">還沒有評論,您來說兩句?</a></p><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/diannaojiqiao/xiaojiqiao.html">電腦小技巧70個</a> (2013-07-09) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Sun, 03 Mar 2019 14:32:22 +0800 win10去除此電腦默認7文件夾/win10還原此電腦默認7文件夾http://www.nsbxbd.tw/system/computerfiles.html<p>根據需求&nbsp;把下列代碼 保存到TXT文檔里面,然后將.txt格式修改為.reg 保存后,雙擊執行;win10去除此電腦默認7文件夾,win10還原此電腦默認7文件夾。</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.nsbxbd.tw/system/computerfiles.html" target="_blank">繼續閱讀《win10去除此電腦默認7文件夾/win10還原此電腦默認7文件夾》的全文內容...</a></p><p>分類: 操作系統技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/%E6%96%87%E4%BB%B6%E5%A4%B9">文件夾</a>, | <a href="http://www.nsbxbd.tw/system/computerfiles.html#comment" target="_blank">添加評論</a>(3)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/system/computerfiles.html#comment-261">2019-03-30 15:13:06 PM</a>,文娛帝國 : 寫的很好,很喜歡</li><li><a href="http://www.nsbxbd.tw/system/computerfiles.html#comment-262">2019-04-01 23:07:50 PM</a>,今日新聞 : 文章不錯非常喜歡</li><li><a href="http://www.nsbxbd.tw/system/computerfiles.html#comment-265">2019-04-02 12:50:34 PM</a>,旋轉門 : 原來還得這樣操作</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/system/qingli.html">Win7清理系統垃圾文件腳本</a> (2017-04-20) </li><li><a href="http://www.nsbxbd.tw/system/1013-windows10.html">Windows10降級教程:降至Win7/Win8.1</a> (2016-10-13) </li><li><a href="http://www.nsbxbd.tw/system/20150422java.html">解決Java(TM)已被阻止,因為它已過時并且需要更新。</a> (2015-04-22) </li><li><a href="http://www.nsbxbd.tw/system/201604desktop.html">電腦開機一直準備桌面</a> (2016-04-03) </li><li><a href="http://www.nsbxbd.tw/system/mail201612.html">郵箱mail的一些常見問題</a> (2016-12-01) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Fri, 22 Feb 2019 16:52:50 +0800 COUNTIFS函數使用技巧二(COUNTIFS一列某個字段數量以及COUNTIFS大于小于統計)http://www.nsbxbd.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.nsbxbd.tw/diannaojiqiao/COUNTIFS2.html" target="_blank">繼續閱讀《COUNTIFS函數使用技巧二(COUNTIFS一列某個字段數量以及COUNTIFS大于小于統計)》的全文內容...</a></p><p>分類: 技巧知識 | Tags: <a href="http://www.nsbxbd.tw/tag/COUNTIFS">COUNTIFS</a>, | <a href="http://www.nsbxbd.tw/diannaojiqiao/COUNTIFS2.html#comment" target="_blank">添加評論</a>(1)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/diannaojiqiao/COUNTIFS2.html#comment-263">2019-04-01 23:09:00 PM</a>,今日新聞 : 文章不錯支持一下</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/software/COUNTIFS.html">COUNTIFS函數使用技巧一(COUNTIFS統計個數以及COUNTIFS統計非空值)</a> (2017-11-09) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.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.nsbxbd.tw/software/Office16.html<p>之前安裝64位office2016,后來卸載準備安裝32位的,安裝時提示&nbsp;安裝錯誤<br/>無法安裝 64 位版本的 Office,因為在您的 PC 上找到了以下 32 位程序:Office 16 Click-to-Run Extensibility Component<br/>請卸載所有 32 位 Office 程序,然后重試安裝 64 位 Office。如果想要安裝 32 位 Office,請運行 32 位安裝程序。<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.nsbxbd.tw/software/Office16.html" target="_blank">繼續閱讀《安裝32位Office 2016 出現 Office 16 Click-to-Run Extensibility Component》的全文內容...</a></p><p>分類: 軟件技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/Office">Office</a>, | <a href="http://www.nsbxbd.tw/software/Office16.html#comment" target="_blank">添加評論</a>(2)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/software/Office16.html#comment-257">2019-02-22 13:44:56 PM</a>,訪客 : 不錯,管用,感謝</li><li><a href="http://www.nsbxbd.tw/software/Office16.html#comment-258">2019-03-17 21:15:04 PM</a>,丘八 : 文章不錯,非常喜歡</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/software/MATCH.html">EXCEL根據行列值查詢得到交叉點值</a> (2018-04-30) </li><li><a href="http://www.nsbxbd.tw/software/word20170310.html">word與EXCEL單元格鏈接更新時產生回車的解決</a> (2017-02-10) </li><li><a href="http://www.nsbxbd.tw/software/model.html">excel中把漢字轉換成拼音</a> (2018-07-09) </li><li><a href="http://www.nsbxbd.tw/software/360tianqing.html">強制卸載360企業版(360天擎)方法</a> (2019-05-15) </li><li><a href="http://www.nsbxbd.tw/software/Flash.html">flash helper service進程廣告解決方法</a> (2018-10-08) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Tue, 25 Dec 2018 12:17:46 +0800 win10查詢自己電腦無線網密碼方法http://www.nsbxbd.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: 右下角 有線/無線 圖標 點擊右鍵,打開網絡和共享中心,&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:命令提示符中輸入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.nsbxbd.tw/system/wifii.html" target="_blank">繼續閱讀《win10查詢自己電腦無線網密碼方法》的全文內容...</a></p><p>分類: 操作系統技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/WIFI">WIFI</a>, | <a href="http://www.nsbxbd.tw/system/wifii.html#comment" target="_blank">添加評論</a>(3)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/system/wifii.html#comment-251">2018-11-19 23:54:16 PM</a>,新聞 : 文章不錯非常喜歡</li><li><a href="http://www.nsbxbd.tw/system/wifii.html#comment-254">2018-12-14 10:11:55 AM</a>,江蘇GRC構件 : 沒事可以在你這里學習學習</li><li><a href="http://www.nsbxbd.tw/system/wifii.html#comment-264">2019-04-02 11:53:57 AM</a>,旋轉門 : 如果忘了是一件真尷尬的事情</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/system/PRINT20171114.html">win7設置局域網共享打印機</a> (2017-11-14) </li><li><a href="http://www.nsbxbd.tw/system/20150301sougou.html">搜狗瀏覽器時出現“您選擇的文件需要相關軟件才能下載,請在安裝軟件后重試”?</a> (2015-03-01) </li><li><a href="http://www.nsbxbd.tw/system/PPOE-bohao.html">超詳細TP-LINK 無線路由器PPPOE撥號上網設置圖文詳解</a> (2016-03-16) </li><li><a href="http://www.nsbxbd.tw/system/qingli.html">Win7清理系統垃圾文件腳本</a> (2017-04-20) </li><li><a href="http://www.nsbxbd.tw/system/arrow.html">解決電腦文件或文件夾右上角出現兩個箭頭</a> (2019-03-03) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Mon, 12 Nov 2018 11:23:20 +0800 flash helper service進程廣告解決方法http://www.nsbxbd.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.nsbxbd.tw/software/Flash.html" target="_blank">繼續閱讀《flash helper service進程廣告解決方法》的全文內容...</a></p><p>分類: 軟件技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/flash">flash</a>, | <a href="http://www.nsbxbd.tw/software/Flash.html#comment" target="_blank">添加評論</a>(1)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/software/Flash.html#comment-274">2019-07-08 22:22:23 PM</a>,訪客 : 用到啦!蟹蟹</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/software/MATCH.html">EXCEL根據行列值查詢得到交叉點值</a> (2018-04-30) </li><li><a href="http://www.nsbxbd.tw/software/Office16.html">安裝32位Office 2016 出現 Office 16 Click-to-Run Extensibility Component</a> (2018-12-25) </li><li><a href="http://www.nsbxbd.tw/software/word20170310.html">word與EXCEL單元格鏈接更新時產生回車的解決</a> (2017-02-10) </li><li><a href="http://www.nsbxbd.tw/software/chrome20170601.html">新版chrome瀏覽器搜索不能顯示漢字的解決辦法</a> (2017-06-01) </li><li><a href="http://www.nsbxbd.tw/software/excel1.html">EXCEL常用技巧1</a> (2017-09-29) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Mon, 08 Oct 2018 13:20:05 +0800 excel中把漢字轉換成拼音http://www.nsbxbd.tw/software/model.html<p>&nbsp;</p><div class="content-list-text"><p>在本地電腦中,打開excel,啟動Excel 2010,打開相應的工作表,同時按“Alt+F11”組合鍵,進入Visual Basic編輯狀態,選擇插入---模塊</p><p>復制并張貼一下內容到上一步打開的編輯界面中。</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.nsbxbd.tw/software/model.html" target="_blank">繼續閱讀《excel中把漢字轉換成拼音》的全文內容...</a></p><p>分類: 軟件技巧 | Tags: <a href="http://www.nsbxbd.tw/tag/excel">excel</a>,<a href="http://www.nsbxbd.tw/tag/%E6%A8%A1%E5%9D%97">模塊</a>, | <a href="http://www.nsbxbd.tw/software/model.html#comment" target="_blank">添加評論</a>(3)</p><hr /> <h3>最新評論:</h3><ul><li><a href="http://www.nsbxbd.tw/software/model.html#comment-246">2018-09-10 23:29:42 PM</a>,頭條 : 文章不錯非常喜歡</li><li><a href="http://www.nsbxbd.tw/software/model.html#comment-247">2018-10-12 10:48:18 AM</a>,江蘇grc : 原來還可以這樣</li><li><a href="http://www.nsbxbd.tw/software/model.html#comment-249">2018-10-19 15:41:55 PM</a>,hebl : 感謝分享 hebl@182hjs.cc</li></ul><h3>相關文章:</h3><ul><li><a href="http://www.nsbxbd.tw/software/tongji20171031.html">Excel中周統計數據的技巧</a> (2017-10-31) </li><li><a href="http://www.nsbxbd.tw/system/excel0409.html">如何對含有回車的單元格進行分列?</a> (2019-04-09) </li><li><a href="http://www.nsbxbd.tw/system/excel20161114.html">excel表格數據全部變成了日期格式</a> (2016-11-14) </li><li><a href="http://www.nsbxbd.tw/software/word20170310.html">word與EXCEL單元格鏈接更新時產生回車的解決</a> (2017-02-10) </li></ul><a target="_blank" title="長大樂憂傷" href="http://www.nsbxbd.tw/"><img alt="Z-Blog" src="http://www.nsbxbd.tw/zb_system/image/admin/none.gif"></a>Mon, 09 Jul 2018 14:43:09 +08002012广东快乐十分平台