Forum Discussion
Solved
Extract Number If Text
I have data in the first column and I want a formula that will return the number before "min" in the 2nd column and the number before "secs" in the 3rd column. MIN SEC 35 secs #N/A 35...
=IFERROR(IF(SEARCH("secs",A2),VALUE(MID(A2,IFERROR(SEARCH("min ",A2)+4,1),2))),NA())
It gives "2" because it can't find "min " (notice the space). change that to "min" instead but then you might have issues with the # characters so change the ,2 to ,3
OR try the FILTERXML formulas
OR try the FILTERXML formulas