=upca Barcode Font Encoder

Pelowtz
Pelowtz
edited 12/09/19 in Formulas and Functions

Hey!

I need to create UPCa text strings in Smartsheet. 

Currently we are using an excel spreadsheet that converts number strings into UPCa font values using an excel VBA macro. 

When I imported my Excel file into smartsheet, this macro was not imported, so the barcode creation functionality is now missing. 

Does Smartsheet have a way to convert numbers into UPCa fonts?

Here's a reference to a similar excel Add-In that essentially does what I'm describing. 

https://support.idautomation.com/Font-Encoders/How-to-create-UPC/EAN-barcodes-in-Excel-using-VBA/_2781

To clarify further, the macro converts a number string like this:

809801931052

Into a text string that our designers can use to create barcodes using a font. The output looks like this:

x(i09801*TMKRQq(v

 

Thanks for any info. 

 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!