How to create barcodes in Excel that WORK!: Find out how you can create UPC-A barcodes in Excel. I tested the barcode with a scanner and it works! You can download the Excel file and use it to generate your own barcode or use it to learn Excel (thank you Pete for sharing).

The solution is a good mix of Excel formulas such as the MOD function, Excel Text functions like LEFT, RIGHT & MID functions as well as Conditional formatting and some Excel VBA. The final result, i.e. the Excel barcode is recognized by the barcode scanner.

If you’d like to learn more about VBA, check out my playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se

Source of the image used in the workbook is from this video – In One Lesson – “How barcodes Work”: https://youtu.be/e6aR1k-ympo

Thank you Pete for sharing this awesome barcode tool with us!

⯆ DOWNLOAD the workbook from here (scroll to the bottom): https://www.xelplus.com/generate-barcodes-excel

LINK to VBA arrays video: https://youtu.be/7uIZg9p-IZQ
Pete’s other video contribution to converts numbers to words: https://youtu.be/1HVLSuAZEtQ

★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

Free Ebook

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

How to create barcodes in Excel that WORK!


Author by: Leila Gharani

SHARE