Working with barcodes in excell

[janfrank]

Hi,

Im having a lot of problems with my barcoding system in excel, if someone could help me out that would be great.

question 1:
Any suggestions on how to generate barcodes real easy? the barcodes we are using are 17 chars long and since excel doesn't work with codes longer than 15 it gives me problems to create barcodes. I want to drag it down to add sequencing numbers but since that does not work i'm changing all end numbers by hand which is a lot of work and i'm pretty sure not the easyest way. Anyone has any suggestions?

example of barcode:

153915012700000001
153915012700000002
153915012700000003

Question 2:
I want to update my prices in my barcoding system but to do that i need to export all the current data first, than change the prices and import all the updated prices again.

The problem im having is when I export the data it comes up in a .csv file, the barcodes however are already changed to 1,2 E+17 numbers.
So I tried exporting them in a different way and now what i have is a list of 5000 barcodes but all with a ; after the barcode itself.

example:
153915012700000001;

The problem is I cant import those barcodes with the ; behind it. Everytime I use a macro, formula or the easy find and replace button all the barcodes change to the 1,2 E+17 numbers which i dont want. (you lose the last 3 numbers of the barcode and it changes to 000 when you rechange it to text format). How can I take out all the ;'s after all the barcodes without them changing to the short code??

Really hope you guys can help

[Kyle123]

A formula to generate barcodes might be:

="1539150127"&TEXT(ROW(A1),"0000000#")  

Obviously depending on how many labels you are likely to need

[sourabhg98]

Ohk
I am just suggesting you one thing....
This would work if text format of barcodes wold work for you....

[janfrank]

Hmm doesn't seem to work for me? Do i need to have something in rowA?

max I will use is 300 barcodes per supplier (first 4 digits of barcode are supplier numbers)

[janfrank]

Tnx Soura, that will work actually. Any idea's for the second question?

[sourabhg98]

check out a substitute function
=SUBSTITUTE(D1,";","")
Hope it helps

If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

[janfrank]

Yup worked great! Tnx so much! will do soura.