Quick Easy Guide:
http://www.miamimanni.com/Home/old-page/bar-codes
This is a five part series discussing how to make bar codes in Microsoft Excel and Word.
I'm not sure if a similar application can be applied to Open Office, but I would imagine there is.
You can consider this a real world case study, a scenario in which you have to package the boxes in the corporate office instead of having the factory workers do it. I'm making this video so someone else doesn't have to suffer through the pain of figuring out how to make these labels on extremely short notice.
The series was originally a 3 part series. After seeing that the series accumulated almost up to 30 minutes of video, I wanted one quick overview video for a user who was moderately proficient with Word and Excel. The overview is about 5 minutes and gives you a good idea of everything you need to know. Also, I put in an Errata video that addresses some tips and mistakes.
::: Quick Overview :::
http://www.youtube.com/watch?v=a-omQUW7b_0
::: 5 min summary of Tutorials :::
http://www.youtube.com/watch?v=kk1stUCoNCU
::: Part 1 :::
http://www.youtube.com/watch?v=kIDQ2NnQsx0
::: Part 2 :::
http://www.youtube.com/watch?v=vYBl987ekIU
::: Part 3 :::
http://www.youtube.com/watch?v=YhDSeviypoQ
Making labels is easier than it looks.
FIRST STEP (Download/Install font)
Get the bar code font that you need. You can Google "code 3 of 9 free," for example. A link is provides on the page.
http://www.squaregear.net/fonts/free3of9.shtml
The installation process is easy. Simply drag and drop the ttf files into the fonts directory in Control Panel.
SECOND STEP (Get your source data ready)
Your source data should be organized by columns. UPC codes should be in on column, product number in another. This also varies from company to company. If you sell one product, the UPC code is going to be the same for each item. So it doesn't necessarily require you to make a column for it. You can specify the UPC code in the Microsoft word.
Also you have to consider preserving the original data, just in case someone before you screwed up. So for example, your given a bunch of MAC addresses for your product, each MAC has hyphens or colons in it segmenting every 2 characters, you can specify in another column to remove that hyphen or Colon. The following code accomplishes this for Cell B2 referencing A2
"=LEFT(A2,2)&RIGHT(LEFT(A2,5),2)&RIGHT(LEFT(A2,8),2)&RIGHT(LEFT(A2,11),2)&RIGHT(LEFT(A2,14),2)&RIGHT(LEFT(A2,17),2)"
THIRD STEP (Preview your data)
Bar code data is a numerical value enclosed with asterisks '*'.
So in one column (the column you will reference) you should have just your numerical value. In another Column, you should should put an asterisk enclosed in double quotes, an ampersand, the reference cell, and another asterisk enclosed in double quotes. Last thing to do here is to change the font to the bar code font.
i.e.
A2 contains 00-44-55-66-77-88
Using the formula earlier, B2 displays 004455667788
Now C2 contains the code: ="*"&B2&"*"
This will display the numerical value in B2 again, but this time with the askerisk enclosing it. So it looks like this: *004455667788*
Lastly you simple change the font, I use "free 3 of 9".
FOURTH STEP (Import data)
This applies to 2003 and 2007
Once everything is said and done now it's time to close your Excel sheet and use Word.
This part of the text tutorial won't get in to much detail. I find this interface to be user friendly, so I'll keep it generic.
Access the labels section in Microsoft Word. Go to options and click create new label. Input specifications like size of the page and the size of the label.
In the mail mergers setting, make sure labels is enabled to have that handy update/refresh values button.
The new record should be in every label after the first one. Edit the first one the way you want it to look, use the beautiful refresh button, sit back and relax.
Loading...
I would just like to write a formula in Excel that would automatically add an asterisk before and after every barcode either prior to or after changing the font to 'Code 39' What would that formula be?
Basically I import a series of numbers into Excel. I would just like to find the easiest way to convert these numbers into barcodes with the asterisks before and after the numbers without manually having to type in the asterisks, which is how I do it now. It gets tedious. Thanks in advance
ThaWhat35 10 months ago