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!