Find and replace or substitute

Options
Desertbird
Desertbird ✭✭
edited 12/27/22 in Formulas and Functions

Hello,

What is the best way to turn ###-###-#### into ########## ? Some entries have parentheses, dashes or spaces, but it needs to pull just the numbers.

I figured it would be either find and replace or substitute, but I'm not sure if I need an additional app to do those. Any help would be appreciated!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!