Excel 提取文本中的多个字段用什么函数或者怎么写VBA?答:在B2中输入或复制粘贴下列公式 =IF(ISNUMBER(FIND("http",A2)),IFERROR(MID(A2,FIND("http",A2),FIND(">",A2)-FIND("http",A2)-1),MID(A2,FIND("http",A2),FIND("<",A2,FIND("<",A2)+1)-FIND("http",A2)-1)),"")下拉填充 ...
excel在长字段中模糊匹配出相同短字段答:公式=IF($C2="","",VLOOKUP(LOOKUP(1,0/(FIND($C2,$A$2:$A$7)),$A$2:$A$7),$A$2:$A$7,1,0))拖动填充柄下拉公式。如图:如果地址全称在sheet2表中,将公式修改成=IF($C2="","",VLOOKUP(LOOKUP(1,0/(FIND($C2,Sheet2!$A$2:$A$7)),Sheet2!$A$2:$A$7),Sheet2!