Forum Discussion

anthonyc89's avatar
anthonyc89
Copper Contributor
Aug 26, 2022

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...
Excel
Formulas and Functions
anthonyc89's avatar
anthonyc89
Copper Contributor
Aug 30, 2022

dscheikey I get a "2" where 15 should read.

 

  • mtarler's avatar
    mtarler
    Silver Contributor
    Aug 30, 2022
    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

Share

Resources