How to make a bar code for scanning on Excel

31
36




About this tutorial:

Video duration: 4:26
Inserting a formula to be able to scan of your laptop

31 COMMENTS

  1. Thanks for posting. Did you ever make a video on how to create a POS system with excel? I've found a video on here but it's useless. I'd appreciate if you could do one.

  2. I am trying to figure out how to scan the barcodes on all my paints and upload all the colors, paint types, and paint tube sizes into an Excel spreadsheet so I can quickly look them up and avoid buying duplicate colors.

  3. 1) You can double-click the line between column headings to resize a column to fit its contents.
    2) Inserting a space between your LOST items and the other data was pointless. The sorter will sort blanks to the bottom anyway.
    3) Highlighting the data to sort was also pointless. Click the column header (SERIALNUMBER), then click Sort & FilterSort A to Z. This will accomplish your sorting goal in two clicks.
    4) When a cell contains numerical data only, Excel will align it to the right for readability. That's why "the generator does that."
    5) The serial number will be aligned to the left anyway when asterisks are inserted by the formula.
    6) When the word "concatenate" appears on your screen, for some reason you read it as "concentrate." Those are two different words. There is no "concentrate" function in Excel.
    7) Every time you type a quotation mark, you call it a "parenthesee."
    8) The singular of "parentheses" is "parenthesis."

  4. This won't work for Code 128 (used much more in professional settings) because barcode fonts rely on a start and stop code for every character – ie,
    instead of "START 12239 STOP", your barcode would scan as
    "START 1 STOP START 2 STOP START 2 STOP START 3 STOP START 9 STOP "
    This evidently results in a needlessly long barcode, which will be more difficult to print correctly and more difficult to scan quickly.
    For these reasons a software plugin is needed which will consider the whole number at once, not every character on its own; most commercial scanners will not scan barcodes made in this way at all.

LEAVE A REPLY

Please enter your comment!
Please enter your name here