How to extract digits from a string that contains numbers and text (+ convert them to values)
Options
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.
Tags:
Answers

The challenge would be that even stripping the letters would still generate a text value due to the comma being there. You would need to parse each entry into its own column to be able to treat them as actual numbers (after stripping the letters).
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!