Split a number using LEFT and Right Formulas

I have a location number that is 6 digits long. I am trying to create a formula using LEFT and Right to add a dash after the first 4 numbers.

EX: if the location number is 123456, I want to create a formula to show 1234-56


Best Answer

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

    Hi @Vincent Carranza ,


    =LEFT([location]@row,4) + "-" + RIGHT([location]@row, 2)

    You'll need to replace [location] with the name of your location number column.



    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!