随笔分类 -  excel

notepad++过滤重复行
摘要：先安装TextFx插件The check boxes and buttons required to do this are located in the menu under: TextFX-->TextFX ToolsMake sure "sort outputs only unique..." is checked. Then select a block of text (ctrl-a to select the entire document). Then click "sort lines case sensitive" or &quo 阅读全文

posted @ 2012-12-21 15:53 haven24 阅读(12562) 评论(0) 推荐(0)

excel提取主域名
摘要：=IF(LEFT(LEFT(SUBSTITUTE(A1,"http://",""),FIND("/",SUBSTITUTE(A1,"http://","")&"/")-1),4)="www.",MID(LEFT(SUBSTITUTE(A1,"http://",""),FIND("/",SUBSTITUTE(A1,"http://","")&& 阅读全文

posted @ 2012-12-21 15:02 haven24 阅读(2497) 评论(0) 推荐(0)

导航