Al sent me a formula to revise. Before:
=IF($B11<>0,IF(OR(ISNUMBER(FIND("-",J11))=TRUE,ISNUMBER(FIND(" ",J11))=TRUE,ISNUMBER(FIND("_",J11))=TRUE),
IF(ISNUMBER(FIND("-",J11))=TRUE,TRIM(SUBSTITUTE(J11,"-","")),IF(ISNUMBER(FIND(" ",J11))=TRUE,TRIM(SUBSTITUTE(J11,"
","")),IF(ISNUMBER(FIND("_",J11))=TRUE,TRIM(SUBSTITUTE(J11,"_","")),TRIM(J11)))),TRIM(J11)),"")
After:
=IF($B1<>0
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/02/10/formula-tips/
Posted
Feb 10 2010, 05:02 PM
by
Daily Dose of Excel