Code 3 of 9 bar codes and Excel

**iIgnite** · 06-13-2011, 09:11 PM

Hi y'all,
I'm needing your help here. I'm trying to use Excel to make 3 of 9 bar codes. The thing about bar codes, or at least the 3 of 9 is that you have to have an * at the beginning and end of the letter/numbers that you want in the bar code. There you go, now you're a bar code expert too for Code 3 of 9!!!

The issue that I'm having is that I have 11 digits setup for each bar code. I put the first number in cell A1 and the next sequential number in A2. I then highlighted A1 and A2 and used the fill (+) feature to create the next numbers in the sequence in column A. Now that I have all of the numbers that I need, How do I get a * at the beginning and end of my numbers in each cell by having all of the numbers highlighted? I don't care to add it to each one individually.
I tried putting *51104000001* in cell A1 and *51104000002* in A2 and used the fill feature, but it didn't continue my number sequence, it only alternated each number listed as I kept moving down the cell.
Your timely help with this issue would be greatly appreciated!! Take care and make it a fantastic day!

**MarvinP** · 06-13-2011, 11:46 PM

Hi ilgnite and welcome to the forum.
Read the "Using More Than One Cell" part of
http://www.excelfunctions.net/Excel-Autofill.html
I think that is what you want. You need to select the two cells and then drag the bottom right corner of the selected cells down.

**Haseeb Avarakkan** · 06-14-2011, 02:37 AM

Hello ilgnite,

Try these,

Enter your first no: in A1

A2, use

="*"&TEXT(SUBSTITUTE(A1,"*",""),"0")&"*"

A3, copy down.

="*"&TEXT(SUBSTITUTE(A2,"*","")+1,"0")&"*"