随笔分类 -  Office

Word/Excel/PPT/pdf
Excel中随机生成6位字符串
摘要：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( 阅读全文

posted @ 2012-05-03 16:34 snigoal 阅读(2985) 评论(0) 推荐(0)

[Alt+Enter]EXCEL中一个表格中输入多行文字
摘要：效果如图： 阅读全文

posted @ 2011-05-09 16:20 snigoal 阅读(464) 评论(0) 推荐(0)