×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Barcode formulas in Excel

Barcode formulas in Excel

Barcode formulas in Excel

(OP)
I'm trying to create a Spreadsheet template that will have daily Inventory Receipts dumped into it.
I want to list the Item number and have a formula in the next column to display the barcode of that item.  I've tried a few ways but none are working.  Does anyone know the exact syntax for a formula and which font would be best to use for a numeric field?
Thanks for any help.

RE: Barcode formulas in Excel

if cell A1 contains  the part number and you want a code39 barcode with a data identifier of 'P' the formula is

="*P"&A1&"*"

if you're using a code39 in the cell

RE: Barcode formulas in Excel

(OP)
I wasn't familiar with a data identifier "P", but
the formula ="*"&A1&"*" worked just fine!  
Thanks for the help!

RE: Barcode formulas in Excel

"P" is probably for an AIAG B-10 label which uses different letters to specify different barcodes on the label.
P=Part number
K=PO
Q=quantity
etc.

DougP, MCP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close