How to remove leading zero's in concatenated cells


I have a series of fields in a sheet, of which only one of those fields is completed each row. I need to combine that series of fields into one field so I don't need to scroll across the sheet.

I have tried using the "=" function so for example


This works and populates correctly in terms of whichever of those cells holds data the final destination cell will show that data. However, it shows with a leading zero, for example


How can I get rid of that leading 0 in the destination cell?

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Or you can use the following formula to remove the 0


    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!