Excel formula required

[sportstar555]

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?

 

[Gordon]

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....)

 

[sportstar555]

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]

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.

:

Concatenate.
Column A=code, Col B= *
then in Col C, =CONCATENATE(B1,A1,B1)

HTH

 

[sportstar555]

Thanks Gordon, that is great!

Concatenate.
Column A=code, Col B= *
then in Col C, =CONCATENATE(B1,A1,B1)

HTH

 

[Gordon]

Thanks Gordon, that is great!

You're welcome

 

[barcodewiz]

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