If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel formula required
I have downloaded a excel font to create a code 39 barcode, and have created
the barcodes. I now need to put an asterix * at the beginning and end of each code, in order for the scanner to recognise them. Please can anyone help? |
#2
|
|||
|
|||
sportstar555 wrote:
I have downloaded a excel font to create a code 39 barcode, and have created the barcodes. I now need to put an asterix * at the beginning and end of each code, in order for the scanner to recognise them. Please can anyone help? Do you not just type in the code (ie *123456789*) and then format it in the barcode font? (I have to say, I ran up an EPOS system last year and don't remember putting "*" at the beginning and end of the numerical code....) |
#3
|
|||
|
|||
Hi there,
Apparently the font used to automatically do this, however it has changed and yes you do have to manually enter the asterix, which would be fine, but i've got 4000 product codes to do. So I wondered if there was a formula to do this for me. "Gordon" wrote: sportstar555 wrote: I have downloaded a excel font to create a code 39 barcode, and have created the barcodes. I now need to put an asterix * at the beginning and end of each code, in order for the scanner to recognise them. Please can anyone help? Do you not just type in the code (ie *123456789*) and then format it in the barcode font? (I have to say, I ran up an EPOS system last year and don't remember putting "*" at the beginning and end of the numerical code....) |
#4
|
|||
|
|||
sportstar555 wrote:
Hi there, Apparently the font used to automatically do this, however it has changed and yes you do have to manually enter the asterix, which would be fine, but i've got 4000 product codes to do. So I wondered if there was a formula to do this for me. "Gordon" wrote: sportstar555 wrote: I have downloaded a excel font to create a code 39 barcode, and have created the barcodes. I now need to put an asterix * at the beginning and end of each code, in order for the scanner to recognise them. Please can anyone help? Do you not just type in the code (ie *123456789*) and then format it in the barcode font? (I have to say, I ran up an EPOS system last year and don't remember putting "*" at the beginning and end of the numerical code....) Concatenate. Column A=code, Col B= * then in Col C, =CONCATENATE(B1,A1,B1) HTH |
#5
|
|||
|
|||
Thanks Gordon, that is great!
"Gordon" wrote: sportstar555 wrote: Hi there, Apparently the font used to automatically do this, however it has changed and yes you do have to manually enter the asterix, which would be fine, but i've got 4000 product codes to do. So I wondered if there was a formula to do this for me. "Gordon" wrote: sportstar555 wrote: I have downloaded a excel font to create a code 39 barcode, and have created the barcodes. I now need to put an asterix * at the beginning and end of each code, in order for the scanner to recognise them. Please can anyone help? Do you not just type in the code (ie *123456789*) and then format it in the barcode font? (I have to say, I ran up an EPOS system last year and don't remember putting "*" at the beginning and end of the numerical code....) Concatenate. Column A=code, Col B= * then in Col C, =CONCATENATE(B1,A1,B1) HTH |
#6
|
|||
|
|||
sportstar555 wrote:
Thanks Gordon, that is great! You're welcome "Gordon" wrote: sportstar555 wrote: Hi there, Apparently the font used to automatically do this, however it has changed and yes you do have to manually enter the asterix, which would be fine, but i've got 4000 product codes to do. So I wondered if there was a formula to do this for me. "Gordon" wrote: sportstar555 wrote: I have downloaded a excel font to create a code 39 barcode, and have created the barcodes. I now need to put an asterix * at the beginning and end of each code, in order for the scanner to recognise them. Please can anyone help? Do you not just type in the code (ie *123456789*) and then format it in the barcode font? (I have to say, I ran up an EPOS system last year and don't remember putting "*" at the beginning and end of the numerical code....) Concatenate. Column A=code, Col B= * then in Col C, =CONCATENATE(B1,A1,B1) HTH |
#7
|
|||
|
|||
You can also do it like this:
="*" & A1 & "*" Keep in mind that if you have any spaces in the barcodes, they will not be encoded correctly. Most Code 39 barcode fonts use underscore (_) instead of space for that reason. The safest way is to create a function, such as: Public Function FormatCode39(d As String) As String FormatCode39 = "*" & Replace(d, " ", "_") & "*" End Function And then use... =FormatCode39(A1) ....in your Formula Bar Regards, Alek Szymanski http://www.barcodewiz.com sportstar555 wrote: Hi there, Apparently the font used to automatically do this, however it has changed and yes you do have to manually enter the asterix, which would be fine, but i've got 4000 product codes to do. So I wondered if there was a formula to do this for me. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I view the actual numeric value of a formula in Excel 2002. | Excel Function Help | Worksheet Functions | 0 | January 13th, 2005 10:07 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Formula result shows as zero Excel 2003 | Serena | General Discussion | 2 | November 7th, 2004 11:21 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |