Results 1 to 6 of 6

Thread: How to use barcodes in Excel

  1. #1
    Join Date
    Aug 2009
    Posts
    59

    How to use barcodes in Excel

    I have downloaded free fonts for barcodes from internet. I want to use in MS Excel. The problem is that it must be added to the asterisk (*) in front of and behind the information to be displayed as a barcode. Example: if I want to go for 'home' in the bar code, it must contain *home*.

    Star symbols indicate the start and stop of the information. But when I try to do so it only comes 'home' into the text field. Can this be done with a formula or formatting? Does anyone know how to use barcodes in Excel?

  2. #2
    Join Date
    Nov 2008
    Posts
    3,952

    Re: How to use barcodes in Excel

    If the column of information is column A and starts in row 1, type the following in row 1 in a free column:

    =CONCATENATE("*";A1;"*")

    Or simply

    ="*"&A1&"*"

    Then, use AutoFill to copy the formula down.

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: How to use barcodes in Excel

    Microsoft Excel does not provide built-in support for bar codes. However, a number of third-party bar code add-ins and devices are available. For example, TALtech has a Bar Code ActiveX Control that can add bar code functionality to your Microsoft Excel.

  4. #4
    Join Date
    Aug 2009
    Posts
    59

    Re: How to use barcodes in Excel

    =CONCATENATE("*";A1;"*")
    It works perfectly well for me and thanks for your help.

    And JonathanD, I don't want to install any more third-party add-ins. However thanks for your information.

  5. #5
    Join Date
    Jul 2013
    Posts
    1

    Re: How to use barcodes in Excel

    can barcode reader help?

  6. #6
    Join Date
    Dec 2007
    Posts
    2,291

    Re: How to use barcodes in Excel

    Quote Originally Posted by cindy313 View Post
    can barcode reader help?

    I havent seen any barcode scanner that will save the scanning results to the excel automatically. But if you know about .net developing then you might try to use a .Net barcode reader sdk that can scan the barcodes and save the scanning results to data strings. You might also be able to write some codes to output the data strings to Excel.

Similar Threads

  1. Replies: 6
    Last Post: 17-02-2012, 01:18 PM
  2. is it possible scan barcodes using Webcam
    By Mullan in forum Technology & Internet
    Replies: 4
    Last Post: 06-02-2012, 06:55 PM
  3. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 05:00 PM
  4. Replies: 6
    Last Post: 17-05-2011, 10:00 PM
  5. Image Processing and Barcodes
    By Author in forum Windows Software
    Replies: 5
    Last Post: 01-04-2010, 06:19 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,633,152.92783 seconds with 17 queries