Friday, February 8, 2019

How to create barcodes using Google Sheets

Alice Keeler says, "The answer is always a spreadsheet" - well - she's right.
Thanks to Katy Barrey and Eric Laszakovits (NISDGoogleGuru) for sharing that Google Sheets can be used to create unique barcodes!

If interested, click on this link How Barcoding Technology Makes Education More Efficient - written in August of 2018.

Below I share the steps on how to create the barcodes.
  • In column C type in the following formula
  • ="*"&B2&"*"
  • Change the font style to Libre Barcode - I chose Libre Barcode39 - and Boom! You have your barcode.
  • Now drag the formula down the column as many as is needed!
Embedded below is a GIF followed by a 1 minute and 3 second YouTube tutorial.




Take care,
Brad

No comments:

Post a Comment