Getting a base number out of a list

RossL ✭✭✭✭✭✭

Hi I could use some help with this list of numbers.

what i am looking to do is come up with a formula that will return 1234 no mater how it is entered. 1234 is just an example number but it could be 52368 or 65875 but it will always be a numeric value needs to be returned. it could have any number of letters or leading zeros in front of it and any number of letters after that would need to be stripped away. Is there a way to do this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!