Share via

Formula for converting text string into barcode

Anonymous
2015-07-21T21:18:13+00:00

Good morning, I have the 128 barcode font in my Excel. I thought that the formula to convert the string went something like ="'*&A2&*'". Can anyone help? Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

16 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-07-28T16:55:00+00:00

    Hello,

    I believe you have the quotes placed incorrectly. Your formula should look like this. ="*"&A2&"*"

    Here is a screen shot of how this works using 3 of 9 barcode, but the priciple is the same. You have to quote each * on the begging and the end. Your current formula returns a value of *&A2&* because you placed your quotes around it all.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2015-07-22T11:37:49+00:00

    128 Barcode Font is not native to Excel.

    Have you downloaded this font from somewhere or do you have some add-in or macro to enable bar code?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-07-28T16:56:55+00:00

    Hi Tony,

    Perhaps I have misunderstood your question, but is it not sufficient simply to change the font?

    ===

    Regards,

    Norman

    Norman,

    Changing the font displays the value as a barcode. However for most barcodes to work they must have a start and stop symbol. As for 3 of 9 and 128 that symbol is *.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2015-07-29T17:21:48+00:00

    Hi James,

    Thank you for your information.

    ===

    Regards,

    Norman

    Was this answer helpful?

    0 comments
  5. Anonymous
    2015-07-21T22:59:43+00:00

    Hi Tony,

    Perhaps I have misunderstood your question, but is it not sufficient simply to change the font?

    ===

    Regards,

    Norman

    Was this answer helpful?

    0 comments