How to extract digits from a string that contains numbers and text (+ convert them to values)


Here are some samples - all I want are the digits in a new cell and for those digits to be values:

170, 191FF

47FF, 54FF

762SS, 22FF

751, 53FF +5d (but I don't want any number that has a "d" with it - "5d")

It's gets complicated if I use IF statements to look for every possible combination of letters that may appear. I'm wondering if an easier approach is to look numbers and extract them as values to a new cell.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!