How would you extract a number from a cell that contains text and numbers?

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi @Jerell Parker ,

    There are several ways to do this. If the number is always the same number of characters and in the same position you can do:

    =VALUE(LEFT([text-num]@row, 6)) where [text-num] is the name of your column with mixed entry.

    If the numbers are always at the beginning of the string but their length varies you can do:

    =VALUE(LEFT([text-num]@row, FIND(" ", [text-num]@row)-1))



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!