Forum Discussion
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())
As variant, for modern Excel
=--TEXTBEFORE(A2, " min",,,,0)
=--LET( s, TEXTBEFORE(A2, " secs",,,,0), TEXTAFTER( s, "min ",,,,s) )
