网络工程师

好好学习，天天向上

日志

用Excel产生6位随机数字和字母组合密码

2009-07-12 13:41:37| 分类：网络管理 | 标签： |字号大中小订阅

由于项目的需要，今天研究一下通过Excel随机产生密码的方法，推荐给大家，非常好用啊！
在单元格内粘贴即可，按F9键可以不断产生：
=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,
CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,
CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),
CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),
CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),
IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))))

评论这张

转发至微博

0人 | 分享到：

阅读(1949)| 评论(1)| 引用 (0) |举报

show interface输出详解

HSRP配置

历史上的今天

this.p={  m:2,
              b:2,
              id:'fks_082071093086083064086082087095086082088069083082086',
              blogTitle:'用Excel产生6位随机数字和字母组合密码',
              blogAbstract:'由于项目的需要，今天研究一下通过Excel随机产生密码的方法，推荐给大家，非常好用啊！<br\>在单元格内粘贴即可，按F9键可以不断产生：<br\>=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,<br\>CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,<br\>CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),<br\>CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),<br\>IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),',
              blogTag:'',
              blogUrl:'blog/static/2496740200961214137231',
              isPublished:1,
              istop:false,
              type:0,
              modifyTime:1247377378452,
              publishTime:1247377297231,
              permalink:'blog/static/2496740200961214137231',
              commentCount:1,
              mainCommentCount:1,
              recommendCount:0,
              bsrk:-100,
              publisherId:0,
              recomBlogHome:false,
              attachmentsFileIds:[],
              vote:{},
              groupInfo:{},
              friendstatus:'none',
              followstatus:'unFollow',
              pubSucc:'',
              visitorProvince:'未设置',
              visitorCity:'未设置',
              postAddInfo:{"postAdSetting":{"title":"youdaonote","linkUrl":"http://g.163.com/a?CID=14253&Values=715242298&Redirect=http://e.cn.miaozhen.com/r.gif?k=1001788&p=3xjnR0&ae=1000240&vo=2ceafe9f2&vr=2&o=http%3A%2F%2Fphdi.qq.com","imageUrl":"http://img1.126.net/channel8/011811_290260_5.24.swf","expireDay":"14","modifyTime":"1337910936457","flashUrl":"http://img1.126.net/channel8/011811_290260_5.24.swf"},"isAdShow":true,"postAdContent":{"special":[{"title":"苏紫紫：和服刑人员子女共同生活","url":"http://suzizi629.blog.163.com/blog/static/17793827720124250249197/"},{"title":"萧锐：警察想'私了'的'呕吐死'奇案","url":"http://xiaorui-1982.blog.163.com/blog/static/131636715201242554036977/"},{"title":"赵格羽：他不是薛平贵你不是王宝钏","url":"http://zhao.geyu.blog.163.com/blog/static/128762728201242592711110/"}],"blog":[{"title":"博主：走近北京纹身族","pic":"http://img5.cache.netease.com/cnews/2012/5/25/20120525081751d3de0.jpg","url":"http://blog.163.com/"},{"title":"英孔子学院院长：不能到处建孔院","url":"http://yaoshujiewy.blog.163.com/blog/static/20087816820124253462376/"},{"title":"茅于轼：追求自由使人们能摆脱贫困","url":"http://maoyushi88.blog.163.com/blog/static/48278451201242434126663/"},{"title":"王旭明：国内车展嫩童模特令人愤怒","url":"http://wang.xuming.blog.163.com/blog/static/135753697201242432740260/"},{"title":"宋石男：张艺谋是被谁气得直尿血？","url":"http://ssnly100.blog.163.com/blog/static/1156339201242585811158/"},{"title":"邝海炎：尝遍百毒和投机献媚的舌尖","url":"http://kuanghaifei.blog.163.com/blog/static/57096697201242510628368/"}]}},
              mset:'000',
              mcon:'',
              srk:-100,
              remindgoodnightblog:false,
              isBlackVisitor:false,
              isShowYodaoAd:false,
              hostIntro:'',
              hmcon:'0',
              lofter_single:'<a hidefocus="true" target="_blank" href="http://www.lofter.com/specials/2012cmvfestival"><img onload="var nimg = new Image(); nimg.src=\'http://blog.163.com/newpage/images/analyse.png?lofter_single&t=\'+new Date().getTime()" border="0" src="http://b2.bst.126.net/newpage/images/lofter_single5.jpg"/></a>'
            }

{list a as x}
    {if !!x}
    <div class="iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
      {if x.visitorName==visitor.userName}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        {if x.moveFrom=='wap'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/wapblog.html?frompersonalbloghome"><span title="来自网易手机博客" class="iblock wapIcon"> </span></a>
        {elseif x.moveFrom=='iphone'}
          <a class="noul pnt" target="_blank"><span title="来自iPhone客户端" class="iblock iphoneIcon"> </span></a>
        {elseif x.moveFrom=='android'}
          <a class="noul pnt" target="_blank"><span title="来自Android客户端" class="iblock androidIcon"> </span></a>
        {elseif x.moveFrom=='mobile'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/emsblog.html?frompersonalbloghome"><span title="来自网易短信写博" class="iblock wapIcon"> </span></a>
        {/if}
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
          ${fn(x.visitorNickname,8)|escape}
        </a>
      </div>
    </div>
    {/if}
    {/list}

<#--最新日志，群博日志--> <#--推荐日志-->

<p class="fc06">推荐过这篇日志的人：</p>
    <div>
      {list a as x}
      {if !!x}
      <div class="iblock nbw-fce nbw-f40">
        <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
        <img alt="${x.recommenderNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.recommenderName)}"/>
        </a>
        <div class="cwd thide">
          <a class="fc03 m2a" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
            ${fn(x.recommenderNickname,6)|escape}
          </a>
        </div>
      </div>
      {/if}
      {/list}
    </div>
    {if !!b&&b.length>0}
    <p  class="fc06">他们还推荐了：</p>
    <ul>
    {list b as y}
      {if !!y}
        <li class="rrb"><span class="iblock">·</span><a class="fc03 m2a" target="_blank" href="http://blog.163.com/${y.recommendBlogPermalink}/?from=blog/static/2496740200961214137231">${y.recommendBlogTitle|escape}</a></li>
      {/if}
    {/list}
    </ul>
    {/if}

<#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--相关文章--> <#--历史上的今天--> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->

页脚

公司简介 - 联系方法 - 招聘信息 - 客户服务 - 隐私政策 - 博客风格 - 手机博客 - VIP博客 - 订阅此博客

网络工程师

导航

日志

用Excel产生6位随机数字和字母组合密码

历史上的今天

相关文章

最近读者

评论

页脚