How to make a bar code for scanning on Excel




About this tutorial:

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

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

31 thoughts on “How to make a bar code for scanning on Excel

    gudkndjbsbslndbdl.b Bholahjxdkkdnvkdmdnd

    (February 26, 2018 - 3:22 am)

    sns retail shotcutr barcod video details

    surinder singh

    (February 26, 2018 - 3:22 am)

    well done job
    it work perfectly

    Raoul Azpeitia

    (February 26, 2018 - 3:22 am)

    I'm not really good at computers how do I get code 39 three text. It not in the font window option. Thanks

    Iraqi for ever

    (February 26, 2018 - 3:22 am)

    just go ahead and use camtasia , you will avoid moving the video back and forth

    abel masangkay

    (February 26, 2018 - 3:22 am)

    Search for "Technitya's Barcode addin", this could help! 🙂

    Govindaraj Prabhu

    (February 26, 2018 - 3:22 am)

    Lovely presentation dzrtrataz. Thank you for your presentaton. I love it.

    Badgerius

    (February 26, 2018 - 3:22 am)

    Useless. Title should say "barcode for required".

    kent D

    (February 26, 2018 - 3:22 am)

    what is a good pos software that's affordable out there?

    Roberto Molina Zuniga

    (February 26, 2018 - 3:22 am)

    Hi thank you for this I need it for my inventory now I can use our system right.

    Thank you very much

    Curtis Heru

    (February 26, 2018 - 3:22 am)

    Wooow!!! Thank You!

    JW

    (February 26, 2018 - 3:22 am)

    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.

    delfinoharrison

    (February 26, 2018 - 3:22 am)

    I have been using technitya barcode addin for this. It works very well for me.

    Jacob Bogart

    (February 26, 2018 - 3:22 am)

    what is the password?? i can't look at the formulas and i want to edit and add some features.

    MOHD FAISAL

    (February 26, 2018 - 3:22 am)

    IN TALLY

    MOHD FAISAL

    (February 26, 2018 - 3:22 am)

    HOW TO MAKE BAR CODE PLS HELP SEND MY E MAIL  ID

    arton ramadani

    (February 26, 2018 - 3:22 am)

    hi! can u pleace tell us what does the colon A,B,C… contain?? like the name or what does it has, what funcion? pleace!! thank you 🙂

    Sarthak Agarwal

    (February 26, 2018 - 3:22 am)

    Is there any way the length of barcode can be shorten from this method ?

    Sean Oliver

    (February 26, 2018 - 3:22 am)

    They are called quotations not parentheses

    dzrtratazvzw

    (February 26, 2018 - 3:22 am)

    My deepest apologize to all the viewers whom have watched this Video and left comments.  I have had issues trying to find a font that works like the one I have.  You can download the font that is similar to mine at the address below.  http://www.fontspace.com/download/19441/998b285df4f5495b8b73afbd6e48919d/idautomationcom_idautomationhc39m.zip

    Gbo Mwms

    (February 26, 2018 - 3:22 am)

    I have Microsoft Excel 2007. I do not have "Code 39" as a font. How can I get this..?

    SimPORTAL 360 Simulation

    (February 26, 2018 - 3:22 am)

    Where do you get the bard code font….

    Michael Chandler

    (February 26, 2018 - 3:22 am)

    You have know idea how much this video has helped me with a project, Thank you i will subscribe to your page.

    Paul Rose

    (February 26, 2018 - 3:22 am)

    Buy a Tripod

    grasshopper21

    (February 26, 2018 - 3:22 am)

    Thank you this worked very well for us.  Can you tell me where you got the font that allows you to print the text underneath?  I believe you called code 39 3 text?

    Thanks

    Joseph Watkins

    (February 26, 2018 - 3:22 am)

    Thanks so much for the info, it was very helpful; Jesus Christ Bless you! 🙂

    Elliott Pew

    (February 26, 2018 - 3:22 am)

    right at about 3:00 I realized this person had no idea what they were talking about…..

    Thomas Moor

    (February 26, 2018 - 3:22 am)

    Hi, could you please let me know the exact name of the font and where I can get it from?

    Eric Hogan

    (February 26, 2018 - 3:22 am)

    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.

    DCMatZoom

    (February 26, 2018 - 3:22 am)

    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."

    Omar Smith

    (February 26, 2018 - 3:22 am)

    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.

    Maxsdiscos

    (February 26, 2018 - 3:22 am)

    Why do you want barcodes in the spreadsheet itself?

Leave a Reply

Your email address will not be published. Required fields are marked *