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(NOT(ISNUMBER(FIND(".",TEXT(A2,"[DBNum2]G/通用格式"),1))),CONCATENATE(TEXT(A2,"[DBNum2]G/通用格式"),"元整"),CONCATENATE(LEFT(TEXT(A2,"[DBNum2]G/通用格式"),FIND(".",TEXT(A2,"[DBNum2]G/通用格式"),1)-1),"元",IF(MID(TEXT(A2,"[...