How to remove the 2 apostrophe while scannig the barcode

Options

Hi All,


I hope all are doing great

I just wanted to check how I can remove the 2 apostrophes from my cell value as I scanned the barcode and I got this value ''0987654321. As I used the VALUE formula but it is not working for apostrophes.


Thanks for the help!

Thanks,

Kaveri Vipat

Senior Associate - Smartsheet Development, Ignatiuz Software

2023 Core Product Certified

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

Answers

  • Samuel Mueller
    Samuel Mueller Overachievers
    Options

    I don't know a lot about barcode scanning.. But could you create a helper column that uses a mid() formula or a right() formula? Right formula if the number of numbers after the " is always the same, otherwise use the mid formula. You could also use =SUBSTITUTE([barcodecolumn]@row, "\"", "") -- If they are actually apostrophes take out the \" and put two apostrophes in between the quotes.

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Options

    Thank you @Samuel Mueller

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

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

  • Samuel Mueller
    Samuel Mueller Overachievers
    Options

    No problem @Kaveri Vipat

    I'm assuming the reason the apostrophe is there because in a barcode you need the leading 0, but as a number a leading zero will be removed because it's not needed.

    Make sure you are aware of that if you remove the apostrophe.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!