Copy part of a code within a cell

Options

Hello community!

I'm looking for a formula or workaround for capturing part of a code in a cell and copying it from another cell

In my contract number column I have 91B023047

I would like to copy B023 to another cell by somehow removing 91 and 047. Is this possible somehow?

Answers

  • ker9
    ker9 ✭✭✭✭✭✭
    Options

    Hi @Sam Swain ,

    If the portion of the contract number you want always begins with the 3rd character and you always want 4 characters, this formula will pull that out:

    =MID([Column3]@row, 3, 4)

    Where [Column3] is your column name.

    Hope this helps!

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    Options

    Hii Sam Swain,

    You can try the below formula for the required condition:

    =MID([Contact number]@row, 3, 4)

    Thank You!

    Anjanesh Vaidya

    Thanks,

    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!