Remove numbers for a code


Is there a way to remove numbers from data in a cell

Lets say the cell says "20-210 Sanitary Sewer" can I have a formula that pulls the 20-210 from the data into another cell?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!