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.
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!